DBA Data[Home] [Help]

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