DBA Data[Home] [Help]

APPS.AME_UTIL dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1958: from per_assignment_status_types

1954: and pas.primary_flag = 'Y'
1955: and pas.assignment_type in ('E','C')
1956: and pas.assignment_status_type_id not in
1957: (select assignment_status_type_id
1958: from per_assignment_status_types
1959: where per_system_status = 'TERM_ASSIGN')
1960: and trunc(sysdate) between pas.effective_start_date and pas.effective_end_date
1961: and (
1962: trunc(sysdate) between pap.effective_start_date and pap.effective_end_date

Line 2188: from per_assignment_status_types

2184: and pas.primary_flag = 'Y'
2185: and pas.assignment_type in ('E','C')
2186: and pas.assignment_status_type_id not in
2187: (select assignment_status_type_id
2188: from per_assignment_status_types
2189: where per_system_status = 'TERM_ASSIGN')
2190: and trunc(sysdate) between pas.effective_start_date and pas.effective_end_date
2191: and (
2192: trunc(sysdate) between pap.effective_start_date and pap.effective_end_date