APPS.PA_ACC_GEN_WF_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES
Line 273: per_assignment_status_types past
269: DECODE(p.current_npw_flag,'Y','CWK','EMP') person_type
270: INTO x_employee_number, l_employee_ccid, x_person_type
271: FROM per_people_f p,
272: per_assignments_f a, 273: per_assignment_status_types past 274: WHERE p.person_id = p_employee_id
275: AND p.business_group_id + 0 = (SELECT nvl(max(fsp.business_group_id),0)
276: FROM financials_system_parameters fsp)
277: AND a.person_id = p.person_id