DBA Data[Home] [Help]

APPS.PAY_GB_REP dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 138: per_assignment_status_types past

134: ppf.full_name,
135: paf.assignment_id
136: from per_all_people_f ppf,
137: per_all_assignments_f paf,
138: per_assignment_status_types past
139: where paf.assignment_status_type_id = past.assignment_status_type_id
140: and past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
141: and ppf.business_group_id = c_business_group_id
142: and paf.payroll_id = c_payroll_id