APPS.PAY_AU_RECON_SUMMARY dependencies on PAY_POPULATION_RANGES

Line 1820: - Uses person_id in pay_population_ranges

1816: /* End of Bug: 3872211 */
1817:
1818: /*
1819: Bug 7138494 - Added Cursor for Range Person
1820: - Uses person_id in pay_population_ranges
1821: --------------------------------------------------------------------+
1822: -- Cursor : c_range_asgids
1823: -- Description : Fetches assignments For Recconciling Payment Summary
1824: -- Returns DISTINCT assignment_id

Line 1845: INDEX(ppr PAY_POPULATION_RANGES_N4)

1841: )
1842: IS
1843: SELECT /*+ INDEX(pap per_people_f_pk)
1844: INDEX(rppa pay_payroll_actions_pk)
1845: INDEX(ppr PAY_POPULATION_RANGES_N4)
1846: INDEX(paa per_assignments_f_N12)
1847: INDEX(pps per_periods_of_service_PK)
1848: */ paa.assignment_id
1849: from per_people_f pap

Line 1853: ,pay_population_ranges ppr

1849: from per_people_f pap
1850: ,per_assignments_f paa
1851: ,pay_payroll_actions rppa
1852: ,per_periods_of_service pps
1853: ,pay_population_ranges ppr
1854: where rppa.payroll_action_id = p_payroll_action_id
1855: and rppa.payroll_action_id = ppr.payroll_action_id
1856: and ppr.chunk_number = p_chunk
1857: and ppr.person_id = pap.person_id

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

2054:
2055: IF l_assignment_id = '%' THEN -- For multiple Assignments
2056:
2057: /* Bug 7138494 - Added Changes for Range Person
2058: - Call Cursor using pay_population_ranges if Range Person Enabled
2059: Else call Old Cursor
2060: */
2061: IF range_person_on
2062: THEN