Explain Plan

[tamilselvan]

Rows      Execution Plan
--------  ----------------------------------------------------
      12  SORT AGGREGATE
       2   SORT GROUP BY
   76563    NESTED LOOPS
   76575     NESTED LOOPS
      19      TABLE ACCESS FULL CN_PAYRUNS_ALL
   76570      TABLE ACCESS BY INDEX ROWID CN_POSTING_DETAILS_ALL
   76570       INDEX RANGE SCAN (object id 178321)
   76563     TABLE ACCESS BY INDEX ROWID CN_PAYMENT_WORKSHEETS_ALL
11432983      INDEX RANGE SCAN (object id 186024)

The plan explains in detail how the rows are gotten. You have to read from the inner most joins.

Step 1 -    Join 2 tables 
        19      TABLE ACCESS FULL CN_PAYRUNS_ALL
   76570      TABLE ACCESS BY INDEX ROWID CN_POSTING_DETAILS_ALL
   76570       INDEX RANGE SCAN (object id 178321)

Step 2  
    Output (76575) of Step 1 joined with 
     76563     TABLE ACCESS BY INDEX ROWID    
                       CN_PAYMENT_WORKSHEETS_ALL
 11432983      INDEX RANGE SCAN (object id 186024)

Step 3  Output from Step-2 is 76563 rows
           Sort Group by is done

Step 4 Sort Aggregate is done