DBA Data[Home] [Help]

APPS.PAY_IE_HIST_ARCH_PKG dependencies on PAY_TEMP_OBJECT_ACTIONS

Line 107: ** will be inserted into pay_temp_object_actions.

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

Line 220: ** pay_temp_object_actions and passes it to the

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

Line 230: from pay_temp_object_actions ptoa

226: p_effective_date in date) IS
227:
228: cursor get_archive_asg_id is
229: select ptoa.object_id assignment_action_id
230: from pay_temp_object_actions ptoa
231: where object_action_id = p_assactid;
232:
233: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
234: l_proc VARCHAR2(50) := g_package || 'archive_historic_data';