APPS.HR_ACCRUAL_PLAN_API dependencies on PAY_ELEMENT_LINKS_F

Line 222: p_absence_link_rec IN pay_element_links_f%rowtype,

218: -- NOTES
219: -- none
220: --
221: PROCEDURE create_element_link(p_element_type_id IN number,
222: p_absence_link_rec IN pay_element_links_f%rowtype,
223: p_legislation_code IN varchar2) is
224: --
225: l_proc varchar2(72);
226: l_max_end_date date;

Line 754: from pay_element_links_f

750: -- copied into links for other elements.
751: --
752: cursor c_absence_element_link_id is
753: select *
754: from pay_element_links_f
755: where element_link_id in ( select pel.element_link_id
756: from pay_element_links_f pel,
757: pay_input_values_f piv
758: where pel.element_type_id = piv.element_type_id

Line 756: from pay_element_links_f pel,

752: cursor c_absence_element_link_id is
753: select *
754: from pay_element_links_f
755: where element_link_id in ( select pel.element_link_id
756: from pay_element_links_f pel,
757: pay_input_values_f piv
758: where pel.element_type_id = piv.element_type_id
759: and piv.input_value_id = p_pto_input_value_id
760: and p_effective_date between pel.effective_start_date

Line 2164: from pay_element_links_f

2160: -- copied into links for other elements.
2161: --
2162: cursor c_absence_element_link_id is
2163: select *
2164: from pay_element_links_f
2165: where element_link_id in ( select distinct pel.element_link_id
2166: from pay_element_links_f pel,
2167: pay_input_values_f piv
2168: where pel.element_type_id = piv.element_type_id

Line 2166: from pay_element_links_f pel,

2162: cursor c_absence_element_link_id is
2163: select *
2164: from pay_element_links_f
2165: where element_link_id in ( select distinct pel.element_link_id
2166: from pay_element_links_f pel,
2167: pay_input_values_f piv
2168: where pel.element_type_id = piv.element_type_id
2169: and piv.input_value_id = p_pto_input_value_id);
2170: