APPS.PAY_AU_REC_DET_PAYSUM_MODE dependencies on PAY_POPULATION_RANGES

Line 575: - Uses person_id in pay_population_ranges

571: and rppa.payroll_id = paaf.payroll_id );
572:
573: /*
574: Bug 7138494 - Added Cursor for Range Person
575: - Uses person_id in pay_population_ranges
576: --------------------------------------------------------------------+
577: -- Cursor : csr_range_assignment_paysum
578: -- Description : Fetches assignments For Recconciling Payment Summary
579: -- Returns DISTINCT assignment_id

Line 603: INDEX(ppr PAY_POPULATION_RANGES_N4)

599: )
600: IS
601: SELECT /*+ INDEX(pap per_people_f_pk)
602: INDEX(rppa pay_payroll_actions_pk)
603: INDEX(ppr PAY_POPULATION_RANGES_N4)
604: INDEX(paa per_assignments_f_N12)
605: INDEX(pps per_periods_of_service_PK)
606: */ paa.assignment_id
607: from per_people_f pap

Line 611: ,pay_population_ranges ppr

607: from per_people_f pap
608: ,per_assignments_f paa
609: ,pay_payroll_actions rppa
610: ,per_periods_of_service pps
611: ,pay_population_ranges ppr
612: WHERE rppa.payroll_action_id = c_payroll_action_id
613: AND rppa.payroll_action_id = ppr.payroll_action_id
614: AND ppr.chunk_number = c_chunk
615: AND pap.person_id = ppr.person_id

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

788: END LOOP;
789: ELSE
790:
791: /* Bug 7138494 - Added Changes for Range Person
792: - Call Cursor using pay_population_ranges if Range Person Enabled
793: Else call Old Cursor
794: */
795:
796: IF range_person_on(g_parameters.report_mode)