APPS.PAY_ELEMENT_LINKS_PKG dependencies on PAY_LINK_INPUT_VALUES_F

Line 162: select rowid, pay_link_input_values_f.*

158: and p_session_date between effective_start_date
159: and effective_end_date;
160: --
161: cursor csr_all_inputs_for_link is
162: select rowid, pay_link_input_values_f.*
163: from pay_link_input_values_f
164: where element_link_id = p_element_link_id
165: for update;
166: --

Line 163: from pay_link_input_values_f

159: and effective_end_date;
160: --
161: cursor csr_all_inputs_for_link is
162: select rowid, pay_link_input_values_f.*
163: from pay_link_input_values_f
164: where element_link_id = p_element_link_id
165: for update;
166: --
167: begin

Line 218: delete from pay_link_input_values_f

214: if p_delete_mode = 'ZAP'
215: or (p_delete_mode = 'DELETE'
216: and fetched_input_value.effective_start_date > p_session_date ) then
217: --
218: delete from pay_link_input_values_f
219: where current of csr_all_inputs_for_link;
220: --
221: -- For date effective deletes, shut down the input value by ensuring its end
222: -- date matches that of its closed parent

Line 228: update pay_link_input_values_f

224: elsif p_delete_mode = 'DELETE'
225: and p_session_date between fetched_input_value.effective_start_date
226: and fetched_input_value.effective_end_date then
227: --
228: update pay_link_input_values_f
229: set effective_end_date = p_session_date
230: where current of csr_all_inputs_for_link;
231: --
232: -- For delete next changes when there are no future rows for the link,

Line 239: update pay_link_input_values_f

235: --
236: elsif p_delete_mode = 'DELETE_NEXT_CHANGE'
237: and p_validation_end_date = hr_general.end_of_time then
238: --
239: update pay_link_input_values_f
240: set effective_end_date = c_end_of_time
241: where --current of csr_all_inputs_for_link
242: rowid = fetched_input_value.rowid
243: and not exists

Line 245: from pay_link_input_values_f pliv

241: where --current of csr_all_inputs_for_link
242: rowid = fetched_input_value.rowid
243: and not exists
244: (select null
245: from pay_link_input_values_f pliv
246: where pliv.element_link_id = fetched_input_value.element_link_id
247: and pliv.input_value_id = fetched_input_value.input_value_id
248: and pliv.effective_start_date > fetched_input_value.effective_start_date);
249: --