APPS.PAY_NO_SC_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 227: SELECT pay_assignment_actions_s.NEXTVAL

223:
224: FOR csr_act IN csr_action_creation(g_business_group_id,g_legal_employer_id,g_effective_date,l_start_date,l_end_date,g_employee_id)
225: LOOP
226:
227: SELECT pay_assignment_actions_s.NEXTVAL
228: INTO l_actid
229: FROM DUAL;
230:
231: hr_nonrun_asact.insact (l_actid,

Line 297: pay_assignment_actions paas,

293: from per_absence_attendances paa,
294: per_absence_attendance_types paat,
295: per_all_assignments_f paaf,
296: per_assignment_status_types past,
297: pay_assignment_actions paas,
298: per_all_people_f papf,
299: hr_soft_coding_keyflex hsc,
300: hr_organization_information hoi
301: where paas.assignment_action_id = p_assignment_action_id