DBA Data[Home] [Help]

APPS.PA_ACC_GEN_WF_PKG dependencies on PER_ASSIGNMENTS_F

Line 272: per_assignments_f a,

268: SELECT DECODE(p.current_npw_flag,'Y',p.npw_number, p.employee_number) employee_number, a.default_code_comb_id,
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)