APPS.PAY_SA_HIST_ARCH_PKG dependencies on PAY_TEMP_OBJECT_ACTIONS

Line 111: ** will be inserted into pay_temp_object_actions.

107: ** Name : action_creation
108: ** Purpose : This procedure fetches archived assignment_action_id's
109: ** from archive table and creates a new temp assignment_action_id
110: ** for each of them. This new temp id along with the archived id
111: ** will be inserted into pay_temp_object_actions.
112: **----------------------------------------------------------**/
113: procedure action_creation(pactid in number,
114: stperson in number,
115: endperson in number,

Line 219: ** pay_temp_object_actions and passes it to the

215:
216: /**------------------------------------------------------------
217: ** Name : archive_historic_data
218: ** Purpose : This procedure gets the archived assignment_action_id from
219: ** pay_temp_object_actions and passes it to the
220: ** get_pay_deduct_element_info procedure to archive payments and
221: ** deductions data.
222: **----------------------------------------------------------**/
223:

Line 229: from pay_temp_object_actions ptoa

225: p_effective_date in date) IS
226:
227: cursor get_archive_asg_id is
228: select ptoa.object_id assignment_action_id
229: from pay_temp_object_actions ptoa
230: where object_action_id = p_assactid;
231:
232: CURSOR get_run_action_det (p_locking_action_id NUMBER) IS
233: SELECT run_assact.assignment_id run_assgt_id