APPS.PAY_GB_PAYSLIP_ARCHIVE dependencies on PAY_POPULATION_RANGES

Line 1889: -- but with a join to pay_population_ranges for performance enhancement

1885: ORDER BY act.assignment_id
1886: FOR UPDATE OF as1.assignment_id;
1887: --
1888: -- csr_range_pre_assignments is a copy of csr_prepaid_assignments
1889: -- but with a join to pay_population_ranges for performance enhancement
1890: -- stperson and endperson are not needed, uses chunk.
1891: --
1892: CURSOR csr_range_pre_assignments(p_pact_id NUMBER,
1893: p_payroll_id NUMBER,

Line 1905: pay_population_ranges ppr

1901: pay_assignment_actions act,
1902: pay_assignment_actions act1,
1903: pay_action_interlocks pai,
1904: per_all_assignments_f as1,
1905: pay_population_ranges ppr
1906: WHERE ppa.payroll_action_id = p_pact_id
1907: AND appa.consolidation_set_id = p_consolidation_id
1908: AND appa.effective_date BETWEEN
1909: ppa.start_date AND ppa.effective_date