APPS.HR_NZ_HOLIDAYS dependencies on PAY_ELEMENT_LINKS_F

Line 163: pay_element_links_f pel,

159: ,p_plan_id IN NUMBER
160: ,p_effective_date IN DATE) IS
161: SELECT LEAST(PEE.EFFECTIVE_START_DATE)
162: FROM pay_element_entries_f pee,
163: pay_element_links_f pel,
164: pay_element_types_f pet,
165: pay_accrual_plans pap
166: where pee.element_link_id = pel.element_link_id
167: and pel.element_type_id = pet.element_type_id

Line 216: pay_element_links_f pel,

212: ,p_plan_category VARCHAR2) IS
213: SELECT pap.accrual_plan_id
214: FROM pay_accrual_plans pap,
215: pay_element_entries_f pee,
216: pay_element_links_f pel,
217: pay_element_types_f pet
218: WHERE pee.assignment_id = p_assignment_id
219: AND p_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date
220: AND pel.element_link_id = pee.element_link_id

Line 1056: pay_element_links_f pel,

1052: ,c_assignment_id IN NUMBER) IS
1053: SELECT pap.accrual_plan_id
1054: FROM pay_accrual_plans pap,
1055: pay_element_entries_f pee,
1056: pay_element_links_f pel,
1057: pay_element_types_f pet
1058: WHERE pel.element_link_id = pee.element_link_id
1059: AND pel.element_type_id = pet.element_type_id
1060: AND pee.assignment_id = c_assignment_id

Line 2068: , pay_element_links_f pel

2064: ,p_effective_date date) is
2065: select pap.accrual_plan_id
2066: from pay_accrual_plans pap
2067: , pay_element_entries_f pee
2068: , pay_element_links_f pel
2069: , pay_element_types_f pet
2070: where pee.assignment_id = p_assignment_id
2071: and p_effective_date between pee.effective_start_date
2072: and pee.effective_end_date

Line 3754: ,pay_element_links_f pel

3750: sum(nvl(to_number(pev1.screen_entry_value),0))
3751: from
3752: pay_accrual_plans pap
3753: ,pay_element_types_f pet
3754: ,pay_element_links_f pel
3755: ,pay_input_values_f piv1
3756: ,pay_input_values_f piv2
3757: ,pay_element_entries_f pee
3758: ,pay_element_entry_values_f pev1