DBA Data[Home] [Help]

APPS.PAY_US_PTO_ACCRUAL dependencies on PAY_ACCRUAL_PLANS

Line 130: FROM pay_accrual_plans pap

126: -- the performance of batch processes such as Checkwriter.
127: --
128: CURSOR csr_use_ff IS
129: SELECT NULL
130: FROM pay_accrual_plans pap
131: ,ff_formulas_f ff
132: WHERE pap.accrual_plan_id = p_plan_id
133: AND pap.accrual_formula_id = ff.formula_id
134: AND p_effective_date BETWEEN

Line 268: from pay_accrual_plans pap,

264: pap.ineligible_period_length,
265: pap.accrual_start,
266: pev.SCREEN_ENTRY_VALUE,
267: pee.element_entry_id
268: from pay_accrual_plans pap,
269: pay_element_entry_values_f pev,
270: pay_element_entries_f pee,
271: pay_element_links_f pel,
272: pay_element_types_f pet,

Line 600: from pay_accrual_plans

596: where pel.element_link_id = pee.element_link_id
597: and pel.element_type_id = pet.element_type_id
598: and pee.assignment_id = p_assignment_id
599: and pet.element_type_id = (select accrual_plan_element_type_id
600: from pay_accrual_plans
601: where accrual_plan_id = p_plan_id)
602: and p_calculation_date between pee.effective_start_date
603: and pee.effective_end_date;
604: