APPS.PAY_ELEMENT_LINKS_PKG dependencies on PAY_LINK_INPUT_VALUES_F

Line 153: select rowid, pay_link_input_values_f.*

149: and p_session_date between effective_start_date
150: and effective_end_date;
151: --
152: cursor csr_all_inputs_for_link is
153: select rowid, pay_link_input_values_f.*
154: from pay_link_input_values_f
155: where element_link_id = p_element_link_id
156: for update;
157: --

Line 154: from pay_link_input_values_f

150: and effective_end_date;
151: --
152: cursor csr_all_inputs_for_link is
153: select rowid, pay_link_input_values_f.*
154: from pay_link_input_values_f
155: where element_link_id = p_element_link_id
156: for update;
157: --
158: begin

Line 209: delete from pay_link_input_values_f

205: if p_delete_mode = 'ZAP'
206: or (p_delete_mode = 'DELETE'
207: and fetched_input_value.effective_start_date > p_session_date ) then
208: --
209: delete from pay_link_input_values_f
210: where current of csr_all_inputs_for_link;
211: --
212: -- For date effective deletes, shut down the input value by ensuring its end
213: -- date matches that of its closed parent

Line 219: update pay_link_input_values_f

215: elsif p_delete_mode = 'DELETE'
216: and p_session_date between fetched_input_value.effective_start_date
217: and fetched_input_value.effective_end_date then
218: --
219: update pay_link_input_values_f
220: set effective_end_date = p_session_date
221: where current of csr_all_inputs_for_link;
222: --
223: -- For delete next changes when there are no future rows for the link,

Line 230: update pay_link_input_values_f

226: --
227: elsif p_delete_mode = 'DELETE_NEXT_CHANGE'
228: and p_validation_end_date = hr_general.end_of_time then
229: --
230: update pay_link_input_values_f
231: set effective_end_date = c_end_of_time
232: where --current of csr_all_inputs_for_link
233: rowid = fetched_input_value.rowid
234: and not exists

Line 236: from pay_link_input_values_f pliv

232: where --current of csr_all_inputs_for_link
233: rowid = fetched_input_value.rowid
234: and not exists
235: (select null
236: from pay_link_input_values_f pliv
237: where pliv.element_link_id = fetched_input_value.element_link_id
238: and pliv.input_value_id = fetched_input_value.input_value_id
239: and pliv.effective_start_date > fetched_input_value.effective_start_date);
240: --