APPS.PAY_IE_NES_REPORT_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1014: ||' FROM per_assignment_status_types '

1010: ||' and papf.business_group_id = paaf.business_group_id and '
1011: ||''''|| g_reference_end_date||''''||' between paaf.effective_start_date and paaf.effective_end_date '
1012: ||' and paaf.person_id = ppf.person_id '
1013: ||' and paaf.assignment_status_type_id in (SELECT assignment_status_type_id '
1014: ||' FROM per_assignment_status_types '
1015: ||' WHERE per_system_status = '||'''ACTIVE_ASSIGN'''
1016: ||' AND active_flag = '||'''Y'''||') '
1017: ||' and paaf.primary_flag= '||'''Y'''
1018: ||' and paaf.employment_category = '

Line 1070: ||' FROM per_assignment_status_types '

1066: ||' and papf.business_group_id = paaf.business_group_id and '
1067: ||''''|| g_reference_end_date||''''||' between paaf.effective_start_date and paaf.effective_end_date '
1068: ||' and paaf.person_id = ppf.person_id '
1069: ||' and paaf.assignment_status_type_id in (SELECT assignment_status_type_id '
1070: ||' FROM per_assignment_status_types '
1071: ||' WHERE per_system_status = '||'''ACTIVE_ASSIGN'''
1072: ||' AND active_flag = '||'''Y'''||') '
1073: ||' and paaf.primary_flag= '||'''Y'''
1074: ||' and paaf.employment_category = '

Line 1296: FROM per_assignment_status_types

1292: and paaf.effective_start_date <= g_reference_end_date
1293: and paaf.effective_end_date >= g_reference_start_date
1294: --
1295: and assignment_status_type_id in (SELECT assignment_status_type_id
1296: FROM per_assignment_status_types
1297: WHERE per_system_status = 'ACTIVE_ASSIGN'
1298: AND active_flag = 'Y')/*6856473 to filter the terminated assingment*/
1299: ORDER BY paaf.effective_start_date desc;
1300: