DBA Data[Home] [Help]

APPS.PAY_NO_ARC_HOLIDAY_ENTITLEMENT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 238: SELECT pay_assignment_actions_s.NEXTVAL

234: g_employee_id,
235: g_assignment_set_id)
236: LOOP
237:
238: SELECT pay_assignment_actions_s.NEXTVAL
239: INTO l_actid
240: FROM DUAL;
241:
242: hr_nonrun_asact.insact (l_actid,

Line 325: pay_assignment_actions paas,

321: past.per_system_status
322: FROM per_all_people_f papf,
323: per_all_assignments_f paaf,
324: per_assignment_status_types past,
325: pay_assignment_actions paas,
326: hr_soft_coding_keyflex hsc,
327: hr_organization_information hoi
328: WHERE paas.assignment_action_id = p_assignment_action_id
329: AND papf.person_id = nvl(csr_v_person_id,papf.person_id)