APPS.HR_EX_EMPLOYEE_API dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 38: from per_assignment_status_types past

34: OR NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
35: and paf.assignment_type in ('E','C')
36: and p_session_date between paf.effective_start_date and paf.effective_end_date
37: and not exists (select 1
38: from per_assignment_status_types past
39: where past.assignment_status_type_id = paf.assignment_status_type_id
40: and past.per_system_status = 'TERM_ASSIGN'
41: and (past.business_group_id = paf.business_group_id
42: OR past.business_group_id is NULL)));

Line 658: l_per_system_status per_assignment_status_types.per_system_status%TYPE;

654: l_max_tpe_end_date per_assignments_f.effective_end_date%TYPE;
655: l_name_combination_warning boolean;
656: l_orig_hire_warning boolean;
657: l_per_object_version_number per_assignments_f.object_version_number%TYPE;
658: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
659: l_person_id per_all_people_f.person_id%TYPE;
660: l_person_type_id per_all_people_f.person_type_id%TYPE;
661: l_person_type_id1 per_all_people_f.person_type_id%TYPE;
662: l_proc varchar2(72)