APPS.PAY_AU_TERMINATIONS dependencies on PAY_ELEMENT_TYPES_F

Line 616: pay_element_types_f pet

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
620: and pel.element_type_id = pet.element_type_id

Line 942: from pay_element_types_f pet,

938: is
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,

Line 1201: from pay_element_types_f petf

1197: (p_effective_date date
1198: ,p_accrual_plan_id number
1199: ) is
1200: select to_number(hrl.description)
1201: from pay_element_types_f petf
1202: , pay_input_values_f pivf
1203: , pay_accrual_plans pap
1204: , hr_lookups hrl
1205: , pay_element_classifications pec

Line 1715: pay_element_types_f pet

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
1719: AND pel.element_type_id = pet.element_type_id

Line 2030: from pay_element_types_f pet,

2026: RETURN VARCHAR2 IS
2027:
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