DBA Data[Home] [Help]

APPS.PAY_IE_LEGISLATIVE_ARCHIVE dependencies on PAY_POPULATION_RANGES

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

2194: ORDER BY act.assignment_id, act.assignment_action_id
2195: FOR UPDATE OF as1.assignment_id;
2196:
2197: -- csr_range_pre_assignments is a copy of csr_prepaid_assignments
2198: -- but with a join to pay_population_ranges for performance enhancement
2199: -- stperson and endperson are not needed, uses chunk.
2200: --
2201: CURSOR csr_range_pre_assignments(p_pact_id NUMBER,
2202: chunk NUMBER,

Line 2216: pay_population_ranges ppr

2212: pay_assignment_actions act,
2213: pay_assignment_actions act1,
2214: pay_action_interlocks pai,
2215: per_assignments_f as1,
2216: pay_population_ranges ppr
2217: WHERE ppa.payroll_action_id = p_pact_id
2218: AND appa.consolidation_set_id = p_consolidation_id
2219: AND appa.effective_date BETWEEN
2220: ppa.start_date AND ppa.effective_date