APPS.PAY_ZA_UPDATE_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 116: pay_element_types_f pet,

112: FROM
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

Line 152: pay_element_types_f pet,

148: SELECT
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

Line 183: pay_element_types_f pet,

179: FROM
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

Line 220: pay_element_types_f et,

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
224: and et.element_type_id = el.element_type_id

Line 360: pay_element_types_f pet,

356: FROM
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