DBA Data[Home] [Help]

APPS.PER_PERSON_INFORMATION dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 115: ,per_assignment_status_types past

111: ,'E','Employee') AsGType
112: ,paf.payroll_id p_id
113: ,papf.payroll_name Pay_Name
114: FROM per_assignments_f paf
115: ,per_assignment_status_types past
116: ,pay_payrolls_f papf
117: WHERE paf.person_id = p_person_id
118: AND past.assignment_status_type_id = paf.assignment_status_type_id
119: AND paf.payroll_id = papf.payroll_id (+)