APPS.PAY_ZA_UPDATE_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 113: pay_element_entries_f pee,

109: BEGIN
110: SELECT
111: peev.screen_entry_value INTO l_result
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,

Line 154: pay_element_entries_f pee,

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
158: AND pee.element_entry_id = p_record.element_entry_id

Line 180: pay_element_entries_f pee,

176: ELSIF p_validation_mode = 'ALREADY_NEW' THEN
177: SELECT
178: peev.screen_entry_value INTO l_result
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,

Line 218: from pay_element_entries_f ee,

214: select ee.effective_start_date,
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

Line 235: from pay_element_entries_f ee

231: and et.effective_end_date;
232:
233: select count(ee.effective_end_date)
234: into l_count
235: from pay_element_entries_f ee
236: where ee.element_entry_id = p_record.element_entry_id
237: and ee.effective_start_date > l_current_eff_end_date;
238:
239: IF l_count > 0 THEN

Line 357: pay_element_entries_f pee,

353: BEGIN
354: SELECT
355: peev.screen_entry_value INTO l_result
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,