DBA Data[Home] [Help]

APPS.PAY_IE_EHECS_REPORT_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 965: FROM per_assignment_status_types

961: and paaf.person_id = c_person_id
962: and paaf.effective_start_date <= g_qtr_end_date
963: and paaf.effective_end_date >= g_qtr_start_date
964: and assignment_status_type_id in (SELECT assignment_status_type_id
965: FROM per_assignment_status_types
966: WHERE per_system_status = 'ACTIVE_ASSIGN'
967: AND active_flag = 'Y')/*6856473 to filter the terminated assingment*/
968: ORDER BY paaf.effective_start_date desc;
969: