APPS.HR_AU_HOLIDAYS dependencies on PAY_ELEMENT_TYPES_F

Line 213: pay_element_types_f pet,

209: pay_element_entries_f pee,
210: pay_element_entry_values_f peev,
211: pay_element_entry_values_f peev1,
212: pay_element_entry_values_f peev2,
213: pay_element_types_f pet,
214: pay_input_values_f piv,
215: pay_input_values_f piv1,
216: pay_input_values_f piv2
217: where pee.assignment_id = p_assignment_id

Line 1200: pay_element_types_f pet

1196: SELECT pap.accrual_plan_id
1197: FROM pay_accrual_plans pap,
1198: pay_element_entries_f pee,
1199: pay_element_links_f pel,
1200: pay_element_types_f pet
1201: WHERE pee.assignment_id = p_assignment_id
1202: AND p_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date
1203: AND p_effective_date BETWEEN pel.effective_start_date AND pel.effective_end_date /*Added for 8482224*/
1204: AND p_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date /*Added for 8482224*/

Line 1768: pay_element_types_f pet

1764: SELECT pap.accrual_plan_id
1765: FROM pay_accrual_plans pap,
1766: pay_element_entries_f pee,
1767: pay_element_links_f pel,
1768: pay_element_types_f pet
1769: WHERE pel.element_link_id = pee.element_link_id
1770: AND pel.element_type_id = pet.element_type_id
1771: AND pee.assignment_id = c_assignment_id
1772: AND pet.element_type_id = pap.accrual_plan_element_type_id

Line 2464: ,pay_element_types_f pet

2460: select
2461: sum(nvl(fnd_number.canonical_to_number(pev1.screen_entry_value),0))
2462: from
2463: pay_accrual_plans pap
2464: ,pay_element_types_f pet
2465: ,pay_element_links_f pel
2466: ,pay_input_values_f piv1
2467: ,pay_input_values_f piv2
2468: ,pay_element_entries_f pee

Line 2691: pay_element_types_f pet,

2687: ,v_calculation_date date )
2688: is
2689: select min(PEE.EFFECTIVE_START_DATE)
2690: from pay_accrual_plans pap,
2691: pay_element_types_f pet,
2692: pay_element_links_f pel,
2693: pay_element_entries_f pee,
2694: per_assignments_f paf,
2695: per_periods_of_service pps