APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 850: from per_assignment_status_types past

846: and p.effective_end_date >= p_primary_date
847: and p.assignment_type in ('E','C')
848: and not exists (
849: select 1
850: from per_assignment_status_types past
851: where past.assignment_status_type_id = p.assignment_status_type_id
852: and past.per_system_status = 'TERM_ASSIGN'
853: and (past.business_group_id = p.business_group_id
854: or past.business_group_id is NULL));

Line 2110: from per_assignment_status_types past

2106: and p.effective_end_date >= p_date_start
2107: and p.assignment_type in ('E','C')
2108: and not exists (
2109: select 1
2110: from per_assignment_status_types past
2111: where past.assignment_status_type_id = p.assignment_status_type_id
2112: and past.per_system_status = 'TERM_ASSIGN'
2113: and (past.business_group_id = p.business_group_id
2114: or past.business_group_id is NULL));

Line 4030: from per_assignment_status_types past

4026: and p.effective_end_date >= p_date_start
4027: and p.assignment_type in ('E','C')
4028: and not exists (
4029: select 1
4030: from per_assignment_status_types past
4031: where past.assignment_status_type_id = p.assignment_status_type_id
4032: and past.per_system_status = 'TERM_ASSIGN'
4033: and (past.business_group_id = p.business_group_id
4034: or past.business_group_id is NULL));

Line 4576: from per_assignment_status_types past

4572: and p.effective_end_date >= p_date_start
4573: and p.assignment_type in ('E','C')
4574: and not exists (
4575: select 1
4576: from per_assignment_status_types past
4577: where past.assignment_status_type_id = p.assignment_status_type_id
4578: and past.per_system_status = 'TERM_ASSIGN'
4579: and (past.business_group_id = p.business_group_id
4580: or past.business_group_id is NULL));