DBA Data[Home] [Help]

APPS.PY_FR_ADDITIONAL_ELEMENT_RULES dependencies on PAY_ELEMENT_LINKS_F

Line 126: from pay_element_links_f

122: --
123:
124: cursor c_absence_element_link_id is
125: select *
126: from pay_element_links_f
127: where element_link_id in ( select pel.element_link_id
128: from pay_element_links_f pel,
129: pay_input_values_f piv
130: where pel.element_type_id = piv.element_type_id

Line 128: from pay_element_links_f pel,

124: cursor c_absence_element_link_id is
125: select *
126: from pay_element_links_f
127: where element_link_id in ( select pel.element_link_id
128: from pay_element_links_f pel,
129: pay_input_values_f piv
130: where pel.element_type_id = piv.element_type_id
131: and piv.input_value_id = p_pto_input_value_id
132: and p_effective_date between pel.effective_start_date