DBA Data[Home] [Help]

APPS.PAY_AU_TERMINATIONS dependencies on PAY_ELEMENT_ENTRIES_F

Line 614: pay_element_entries_f pee,

610: ,p_plan_category varchar2
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

Line 943: pay_element_entries_f peef,

939: select peev.screen_entry_value,
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,

Line 1713: pay_element_entries_f pee,

1709: ,p_effective_date DATE
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

Line 2032: pay_element_entries_f pee,

2028: cursor csr_check_trans is
2029: select 1
2030: from pay_element_types_f pet,
2031: pay_input_values_f piv,
2032: pay_element_entries_f pee,
2033: pay_element_entry_values_f peev
2034: where pee.assignment_id = p_assignment_id
2035: and pet.element_type_id = piv.element_type_id
2036: and pet.element_name = 'ETP on Termination'