APPS.PAY_ZA_UPDATE_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 117: pay_element_links_f pel,

113: pay_element_entries_f pee,
114: pay_element_entry_values_f peev,
115: pay_input_values_f piv,
116: pay_element_types_f pet,
117: pay_element_links_f pel,
118: per_assignments_f pa
119: WHERE
120: pee.element_entry_id = peev.element_entry_id
121: AND piv.input_value_id = peev.input_value_id

Line 153: pay_element_links_f pel,

149: COUNT(piv.input_value_id) INTO l_count
150: FROM
151: pay_input_values_f piv,
152: pay_element_types_f pet,
153: pay_element_links_f pel,
154: pay_element_entries_f pee,
155: pay_element_entry_values_f peev
156: WHERE
157: pee.element_entry_id = peev.element_entry_id

Line 184: pay_element_links_f pel,

180: pay_element_entries_f pee,
181: pay_element_entry_values_f peev,
182: pay_input_values_f piv,
183: pay_element_types_f pet,
184: pay_element_links_f pel,
185: per_assignments_f pa
186: WHERE
187: pee.element_entry_id = peev.element_entry_id
188: AND piv.input_value_id = peev.input_value_id

Line 219: pay_element_links_f el,

215: ee.effective_end_date
216: into l_current_eff_start_date,
217: l_current_eff_end_date
218: from pay_element_entries_f ee,
219: pay_element_links_f el,
220: pay_element_types_f et,
221: pay_element_classifications ec
222: where ee.element_entry_id = p_record.element_entry_id
223: and el.element_link_id = ee.element_link_id

Line 361: pay_element_links_f pel,

357: pay_element_entries_f pee,
358: pay_element_entry_values_f peev,
359: pay_input_values_f piv,
360: pay_element_types_f pet,
361: pay_element_links_f pel,
362: per_assignments_f pa
363: WHERE
364: pee.element_entry_id = peev.element_entry_id
365: AND piv.input_value_id = peev.input_value_id