APPS.AME_APPROVER_TYPE_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 660: from per_assignment_status_types

656: per_all_assignments_f.primary_flag = 'Y' and
657: per_all_assignments_f.assignment_type in ('E','C') and
658: per_all_assignments_f.assignment_status_type_id not in
659: (select assignment_status_type_id
660: from per_assignment_status_types
661: where per_system_status = 'TERM_ASSIGN') and
662: trunc(sysdate) between
663: per_all_assignments_f.effective_start_date and
664: per_all_assignments_f.effective_end_date;

Line 1452: from per_assignment_status_types

1448: per_all_assignments_f.primary_flag = 'Y' and
1449: per_all_assignments_f.assignment_type in ('E','C') and
1450: per_all_assignments_f.assignment_status_type_id not in
1451: (select assignment_status_type_id
1452: from per_assignment_status_types
1453: where per_system_status = 'TERM_ASSIGN') and
1454: trunc(sysdate) between
1455: per_all_assignments_f.effective_start_date and
1456: per_all_assignments_f.effective_end_date and

Line 1494: from per_assignment_status_types

1490: per_all_assignments_f.primary_flag = 'Y' and
1491: per_all_assignments_f.assignment_type in ('E','C') and
1492: per_all_assignments_f.assignment_status_type_id not in
1493: (select assignment_status_type_id
1494: from per_assignment_status_types
1495: where per_system_status = 'TERM_ASSIGN') and
1496: trunc(sysdate) between
1497: per_all_assignments_f.effective_start_date and
1498: per_all_assignments_f.effective_end_date and

Line 1647: from per_assignment_status_types

1643: per_all_assignments_f.primary_flag = 'Y' and
1644: per_all_assignments_f.assignment_type in ('E','C') and
1645: per_all_assignments_f.assignment_status_type_id not in
1646: (select assignment_status_type_id
1647: from per_assignment_status_types
1648: where per_system_status = 'TERM_ASSIGN') and
1649: trunc(sysdate) between
1650: per_all_assignments_f.effective_start_date and
1651: per_all_assignments_f.effective_end_date and

Line 1688: from per_assignment_status_types

1684: per_all_assignments_f.primary_flag = 'Y' and
1685: per_all_assignments_f.assignment_type in ('E','C') and
1686: per_all_assignments_f.assignment_status_type_id not in
1687: (select assignment_status_type_id
1688: from per_assignment_status_types
1689: where per_system_status = 'TERM_ASSIGN') and
1690: trunc(sysdate) between
1691: per_all_assignments_f.effective_start_date and
1692: per_all_assignments_f.effective_end_date and

Line 1960: from per_assignment_status_types

1956: and pas.primary_flag = 'Y'
1957: and pas.assignment_type in ('E','C')
1958: and pas.assignment_status_type_id not in
1959: (select assignment_status_type_id
1960: from per_assignment_status_types
1961: where per_system_status = 'TERM_ASSIGN')
1962: and wfr.orig_system_id = pap.person_id
1963: and wfr.orig_system = ame_util.perOrigSystem
1964: and wfr.status = 'ACTIVE'