APPS.AME_APPROVER_TYPE_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 699: from per_assignment_status_types

695: per_all_assignments_f.primary_flag = 'Y' and
696: per_all_assignments_f.assignment_type in ('E','C') and
697: per_all_assignments_f.assignment_status_type_id not in
698: (select assignment_status_type_id
699: from per_assignment_status_types
700: where per_system_status = 'TERM_ASSIGN') and
701: trunc(sysdate) between
702: per_all_assignments_f.effective_start_date and
703: per_all_assignments_f.effective_end_date;

Line 1496: from per_assignment_status_types

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

Line 1538: from per_assignment_status_types

1534: per_all_assignments_f.primary_flag = 'Y' and
1535: per_all_assignments_f.assignment_type in ('E','C') and
1536: per_all_assignments_f.assignment_status_type_id not in
1537: (select assignment_status_type_id
1538: from per_assignment_status_types
1539: where per_system_status = 'TERM_ASSIGN') and
1540: trunc(sysdate) between
1541: per_all_assignments_f.effective_start_date and
1542: per_all_assignments_f.effective_end_date and

Line 1691: from per_assignment_status_types

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

Line 1732: from per_assignment_status_types

1728: per_all_assignments_f.primary_flag = 'Y' and
1729: per_all_assignments_f.assignment_type in ('E','C') and
1730: per_all_assignments_f.assignment_status_type_id not in
1731: (select assignment_status_type_id
1732: from per_assignment_status_types
1733: where per_system_status = 'TERM_ASSIGN') and
1734: trunc(sysdate) between
1735: per_all_assignments_f.effective_start_date and
1736: per_all_assignments_f.effective_end_date and

Line 2009: from per_assignment_status_types

2005: and pas.primary_flag = 'Y'
2006: and pas.assignment_type in ('E','C')
2007: and pas.assignment_status_type_id not in
2008: (select assignment_status_type_id
2009: from per_assignment_status_types
2010: where per_system_status = 'TERM_ASSIGN')
2011: and wfr.orig_system_id = pap.person_id
2012: and wfr.orig_system = ame_util.perOrigSystem
2013: and wfr.status = 'ACTIVE'