DBA Data[Home] [Help]

APPS.PAY_GB_PAYSLIP_ARCHIVE dependencies on PAY_POPULATION_RANGES

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

1816: ORDER BY act.assignment_id
1817: FOR UPDATE OF as1.assignment_id;
1818: --
1819: -- csr_range_pre_assignments is a copy of csr_prepaid_assignments
1820: -- but with a join to pay_population_ranges for performance enhancement
1821: -- stperson and endperson are not needed, uses chunk.
1822: --
1823: CURSOR csr_range_pre_assignments(p_pact_id NUMBER,
1824: p_payroll_id NUMBER,

Line 1836: pay_population_ranges ppr

1832: pay_assignment_actions act,
1833: pay_assignment_actions act1,
1834: pay_action_interlocks pai,
1835: per_all_assignments_f as1,
1836: pay_population_ranges ppr
1837: WHERE ppa.payroll_action_id = p_pact_id
1838: AND appa.consolidation_set_id = p_consolidation_id
1839: AND appa.effective_date BETWEEN
1840: ppa.start_date AND ppa.effective_date