APPS.PER_PEOPLE3_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 75: from per_assignment_status_types past

71: -- Define Cursor.
72: --
73: cursor per_type is
74: select past.assignment_status_type_id
75: from per_assignment_status_types past
76: , per_ass_status_type_amends pasa
77: where pasa.assignment_status_type_id(+) = past.assignment_status_type_id
78: and pasa.business_group_id(+) + 0 = p_business_group_id
79: and nvl(past.business_group_id,p_business_group_id) = p_business_group_id

Line 654: , per_assignment_status_types pas

650: cursor app_ass(p_last_vacancy number) is
651: select pav.vacancy_id,pav.name
652: ,pa.assignment_id -- #2381925
653: from per_assignments pa, per_all_vacancies pav
654: , per_assignment_status_types pas
655: where person_id = p_person_id
656: and pav.vacancy_id = pa.vacancy_id
657: and pa.assignment_status_type_id = pas.assignment_status_type_id
658: and pas.per_system_status = 'ACCEPTED'

Line 737: , per_assignment_status_types past

733: --
734: select count(pa.assignment_id)
735: into p_num_accepted_appls
736: from per_assignments pa
737: , per_assignment_status_types past
738: where pa.person_id = p_person_id
739: and pa.assignment_status_type_id = past.assignment_status_type_id
740: and past.per_system_status = 'ACCEPTED';
741: --

Line 754: , per_assignment_status_types past

750: begin
751: select pa.assignment_id
752: into p_new_primary_id
753: from per_assignments pa
754: , per_assignment_status_types past
755: where pa.person_id = p_person_id
756: and pa.assignment_status_type_id = past.assignment_status_type_id
757: and past.per_system_status = 'ACCEPTED';
758: exception