DBA Data[Home] [Help]

APPS.PAY_US_PTO_ACCRUAL dependencies on PAY_ACCRUAL_PLANS

Line 125: FROM pay_accrual_plans pap

121: -- the performance of batch processes such as Checkwriter.
122: --
123: CURSOR csr_use_ff IS
124: SELECT NULL
125: FROM pay_accrual_plans pap
126: ,ff_formulas_f ff
127: WHERE pap.accrual_plan_id = p_plan_id
128: AND pap.accrual_formula_id = ff.formula_id
129: AND p_effective_date BETWEEN

Line 263: from pay_accrual_plans pap,

259: pap.ineligible_period_length,
260: pap.accrual_start,
261: pev.SCREEN_ENTRY_VALUE,
262: pee.element_entry_id
263: from pay_accrual_plans pap,
264: pay_element_entry_values_f pev,
265: pay_element_entries_f pee,
266: pay_element_links_f pel,
267: pay_element_types_f pet,