APPS.PAY_AU_PAYMENT_SUMMARY dependencies on PAY_POPULATION_RANGES

Line 854: - Uses person_id in pay_population_ranges

850:
851:
852: /*
853: Bug 7138494 - Added Cursor for Range Person
854: - Uses person_id in pay_population_ranges
855: --------------------------------------------------------------------+
856: -- Cursor : range_process_assignments
857: -- Description : Fetches assignments For Recconciling Payment Summary
858: -- Returns DISTINCT assignment_id

Line 868: INDEX(ppr PAY_POPULATION_RANGES_N4)

864: c_chunk IN NUMBER)
865: IS
866: SELECT /*+ INDEX(pap per_people_f_pk)
867: INDEX(rppa pay_payroll_actions_pk)
868: INDEX(ppr PAY_POPULATION_RANGES_N4)
869: INDEX(paa per_assignments_f_N12)
870: INDEX(pps per_periods_of_service_PK)
871: */ a.assignment_id
872: FROM per_people_f p /*Bug3043049*/

Line 876: ,pay_population_ranges ppr

872: FROM per_people_f p /*Bug3043049*/
873: ,per_assignments_f a /*Bug3043049*/
874: ,pay_payroll_actions pa
875: ,per_periods_of_service pps
876: ,pay_population_ranges ppr
877: WHERE pa.payroll_action_id = c_payroll_action_id
878: AND pa.payroll_action_id = ppr.payroll_action_id
879: AND ppr.chunk_number = c_chunk
880: AND p.person_id = ppr.person_id

Line 1068: - Call Cursor using pay_population_ranges if Range Person Enabled

1064: else
1065: /* Multiple Assignments */
1066:
1067: /* Bug 7138494 - Added Changes for Range Person
1068: - Call Cursor using pay_population_ranges if Range Person Enabled
1069: Else call Old Cursor
1070: */
1071:
1072: IF range_person_on