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 2156: from pay_element_links_f

2152: -- copied into links for other elements.
2153: --
2154: cursor c_absence_element_link_id is
2155: select *
2156: from pay_element_links_f
2157: where element_link_id in ( select distinct pel.element_link_id
2158: from pay_element_links_f pel,
2159: pay_input_values_f piv
2160: where pel.element_type_id = piv.element_type_id

Line 2158: from pay_element_links_f pel,

2154: cursor c_absence_element_link_id is
2155: select *
2156: from pay_element_links_f
2157: where element_link_id in ( select distinct pel.element_link_id
2158: from pay_element_links_f pel,
2159: pay_input_values_f piv
2160: where pel.element_type_id = piv.element_type_id
2161: and piv.input_value_id = p_pto_input_value_id);
2162: