DBA Data[Home] [Help]

APPS.PAY_AU_TERMINATIONS dependencies on PAY_ELEMENT_LINKS_F

Line 615: pay_element_links_f pel,

611: ) is
612: select pap.accrual_plan_id
613: from pay_accrual_plans pap,
614: pay_element_entries_f pee,
615: pay_element_links_f pel,
616: pay_element_types_f pet
617: where pee.assignment_id = p_assignment_id
618: and p_effective_date between pee.effective_start_date and pee.effective_end_date
619: and pel.element_link_id = pee.element_link_id

Line 944: pay_element_links_f pel,

940: peev1.screen_entry_value,
941: to_date(peev2.screen_entry_value,'YYYY/MM/DD HH24:MI:SS')
942: from pay_element_types_f pet,
943: pay_element_entries_f peef,
944: pay_element_links_f pel,
945: pay_input_values_f piv,
946: pay_input_values_f piv1,
947: pay_input_values_f piv2,
948: pay_element_entry_values_f peev,

Line 1714: pay_element_links_f pel,

1710: ,p_plan_category VARCHAR2) IS
1711: SELECT pap.accrual_plan_id,pap.accrual_units_of_measure
1712: FROM pay_accrual_plans pap,
1713: pay_element_entries_f pee,
1714: pay_element_links_f pel,
1715: pay_element_types_f pet
1716: WHERE pee.assignment_id = p_assignment_id
1717: AND p_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date
1718: AND pel.element_link_id = pee.element_link_id