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 550: , per_assignment_status_types pas

546: cursor app_ass(p_last_vacancy number) is
547: select pav.vacancy_id,pav.name
548: ,pa.assignment_id -- #2381925
549: from per_assignments pa, per_all_vacancies pav
550: , per_assignment_status_types pas
551: where person_id = p_person_id
552: and pav.vacancy_id = pa.vacancy_id
553: and pa.assignment_status_type_id = pas.assignment_status_type_id
554: and pas.per_system_status = 'ACCEPTED'

Line 633: , per_assignment_status_types past

629: --
630: select count(pa.assignment_id)
631: into p_num_accepted_appls
632: from per_assignments pa
633: , per_assignment_status_types past
634: where pa.person_id = p_person_id
635: and pa.assignment_status_type_id = past.assignment_status_type_id
636: and past.per_system_status = 'ACCEPTED';
637: --

Line 650: , per_assignment_status_types past

646: begin
647: select pa.assignment_id
648: into p_new_primary_id
649: from per_assignments pa
650: , per_assignment_status_types past
651: where pa.person_id = p_person_id
652: and pa.assignment_status_type_id = past.assignment_status_type_id
653: and past.per_system_status = 'ACCEPTED';
654: exception