APPS.PAY_GB_HIST_ARCH_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 128: pay_assignment_actions paa,

124: paaf.assignment_id,
125: ppa.effective_date
126: from per_all_assignments_f paaf,
127: pay_payroll_actions ppa,
128: pay_assignment_actions paa,
129: pay_action_interlocks lck,
130: pay_payroll_actions ppa1,
131: pay_assignment_actions paa1
132: where paa.SOURCE_ACTION_ID is null

Line 131: pay_assignment_actions paa1

127: pay_payroll_actions ppa,
128: pay_assignment_actions paa,
129: pay_action_interlocks lck,
130: pay_payroll_actions ppa1,
131: pay_assignment_actions paa1
132: where paa.SOURCE_ACTION_ID is null
133: and paaf.person_id between stperson
134: and endperson
135: and ppa.report_type = 'UKPS'

Line 188: select pay_assignment_actions_s.nextval

184: hr_utility.set_location('endperson :' ||endperson ,10);
185:
186: for asgrec in get_assignment_id(l_payroll_id,l_bg_id,l_start_date,l_end_date)
187: loop
188: select pay_assignment_actions_s.nextval
189: into lockingactid
190: from dual;
191:
192: 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: begin
235:
236: hr_utility.trace('Entering archive_historic_data');
237: hr_utility.set_location('Current assignment_action_id - p_assactid: '