APPS.PAY_IE_EHECS_REPORT_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1141: FROM per_assignment_status_types

1137: and paaf.person_id = c_person_id
1138: and paaf.effective_start_date <= g_qtr_end_date
1139: and paaf.effective_end_date >= g_qtr_start_date
1140: and assignment_status_type_id in (SELECT assignment_status_type_id
1141: FROM per_assignment_status_types
1142: WHERE per_system_status = 'ACTIVE_ASSIGN'
1143: AND active_flag = 'Y')/*6856473 to filter the terminated assingment*/
1144: and papf.payroll_id=paaf.payroll_id -- 9776525
1145: ORDER BY paaf.effective_start_date desc;