APPS.PAY_IE_HIST_ARCH_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 123: pay_assignment_actions paa,

119: paaf.assignment_id,
120: ppa.effective_date
121: from per_all_assignments_f paaf,
122: pay_payroll_actions ppa,
123: pay_assignment_actions paa,
124: pay_action_interlocks lck,
125: pay_payroll_actions ppa1,
126: pay_assignment_actions paa1
127: where paa.SOURCE_ACTION_ID is null

Line 126: pay_assignment_actions paa1

122: pay_payroll_actions ppa,
123: pay_assignment_actions paa,
124: pay_action_interlocks lck,
125: pay_payroll_actions ppa1,
126: pay_assignment_actions paa1
127: where paa.SOURCE_ACTION_ID is null
128: and paaf.person_id between stperson and endperson
129: and ppa.report_type = 'IEPS'
130: and ppa.action_type ='X'

Line 185: select pay_assignment_actions_s.nextval

181:
182: for asgrec in get_arch_action_det(l_payroll_id,l_bg_id,l_start_date,l_end_date)
183: loop
184:
185: select pay_assignment_actions_s.nextval
186: into lockingactid
187: from dual;
188:
189: hr_nonrun_asact.insact

Line 233: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

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';
235:
236: begin
237: hr_utility.set_location('Entering ' || l_proc,10);