DBA Data[Home] [Help]

APPS.HR_AU_HOLIDAYS dependencies on PAY_ELEMENT_TYPES_F

Line 97: pay_element_types_f pet

93: SELECT pap.accrual_plan_id
94: FROM pay_accrual_plans pap,
95: pay_element_entries_f pee,
96: pay_element_links_f pel,
97: pay_element_types_f pet
98: WHERE pee.assignment_id = p_assignment_id
99: AND p_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date
100: AND pel.element_link_id = pee.element_link_id
101: AND pel.element_type_id = pet.element_type_id

Line 546: pay_element_types_f pet

542: SELECT pap.accrual_plan_id
543: FROM pay_accrual_plans pap,
544: pay_element_entries_f pee,
545: pay_element_links_f pel,
546: pay_element_types_f pet
547: WHERE pel.element_link_id = pee.element_link_id
548: AND pel.element_type_id = pet.element_type_id
549: AND pee.assignment_id = c_assignment_id
550: AND pet.element_type_id = pap.accrual_plan_element_type_id

Line 1242: ,pay_element_types_f pet

1238: select
1239: sum(nvl(to_number(pev1.screen_entry_value),0))
1240: from
1241: pay_accrual_plans pap
1242: ,pay_element_types_f pet
1243: ,pay_element_links_f pel
1244: ,pay_input_values_f piv1
1245: ,pay_input_values_f piv2
1246: ,pay_element_entries_f pee