DBA Data[Home] [Help]

APPS.PAY_US_PTO_ACCRUAL dependencies on PAY_ELEMENT_ENTRIES_F

Line 270: pay_element_entries_f pee,

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,
273: pay_input_values_f piv
274: where ( pap.accrual_plan_id = p_plan_id OR

Line 593: from pay_element_entries_f pee,

589: IF l_csd_screen_value is null then
590: hr_utility.set_location('get_accrual',811);
591:
592: select min (pee.effective_start_date) into l_plan_enrl_date
593: from pay_element_entries_f pee,
594: pay_element_links_f pel,
595: pay_element_types_f pet
596: where pel.element_link_id = pee.element_link_id
597: and pel.element_type_id = pet.element_type_id

Line 753: from pay_element_entries_f

749: --
750: hr_utility.set_location('get_accrual',65);
751: select min(effective_start_date)
752: into l_plan_start_date
753: from pay_element_entries_f
754: where element_entry_id = l_element_entry_id;
755: hr_utility.set_location('get_accrual',67);
756: ---
757: