APPS.PER_HU_EMP_CERT_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 193: ,pay_assignment_actions act -- Bug Fix 4369797 Changed table order

189: AND ppos.actual_termination_date BETWEEN ppa.start_date
190: AND ppa.effective_date
191: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
192: FROM pay_payroll_actions appa
193: ,pay_assignment_actions act -- Bug Fix 4369797 Changed table order
194: ,pay_action_information pai
195: WHERE appa.action_status = 'C'
196: AND appa.report_type = 'HU_EMP_CERT'
197: AND appa.report_category = 'ARCHIVE'

Line 233: SELECT pay_assignment_actions_s.NEXTVAL

229: ,stperson
230: ,endperson
231: ,l_payroll_id) LOOP
232: --
233: SELECT pay_assignment_actions_s.NEXTVAL
234: INTO l_actid
235: FROM dual;
236: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
237: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,p_actid,chunk,NULL);

Line 363: ,pay_assignment_actions paas

359: ,paas.payroll_action_id
360: FROM per_all_people_F pap
361: ,per_periods_of_service ppf
362: ,per_all_assignments_f paa
363: ,pay_assignment_actions paas
364: ,hr_soft_coding_keyflex hr
365: ,hr_organization_information hoi
366: WHERE paas.assignment_action_id = p_assactid
367: AND paas.assignment_id = paa.assignment_id