APPS.HREMPTER dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 2594: FROM per_assignment_status_types

2590: --
2591: hr_utility.set_location(l_proc,65);
2592: SELECT per_system_status
2593: INTO l_per_system_status
2594: FROM per_assignment_status_types
2595: WHERE assignment_status_type_id = c_ass_rec.assignment_status_type_id;
2596: --
2597: hr_utility.set_location(l_proc,70);
2598: TA_FLAG := (l_per_system_status = 'TERM_ASSIGN' AND

Line 2689: -- both the per_assignment_status_types table and the

2685: -- Terminated Assignment record, and fails because
2686: -- ASSIGNMENT_STATUS_TYPE_ID is mandatory. Fix is to get the default
2687: -- TERM_ASSIGN status immediately before the insert, if one hasn't
2688: -- already been passed in. The code looks for the default status in
2689: -- both the per_assignment_status_types table and the
2690: -- per_ass_status_type_amends table.
2691: --
2692: if p_assignment_status_type_id is null then
2693: select stt.assignment_status_type_id

Line 2695: from per_assignment_status_types stt,

2691: --
2692: if p_assignment_status_type_id is null then
2693: select stt.assignment_status_type_id
2694: into l_assignment_status_type_id
2695: from per_assignment_status_types stt,
2696: per_ass_status_type_amends sta
2697: where nvl(sta.per_system_status,stt.per_system_status) =
2698: 'TERM_ASSIGN'
2699: and stt.assignment_status_type_id =

Line 3421: from per_assignments_f ass1, per_assignment_status_types past

3417: or
3418: (p_actual_termination_date <> nvl(lp_final_process_date,to_date('31/12/4712','dd/mm/yyyy'))
3419: and
3420: exists (select 1
3421: from per_assignments_f ass1, per_assignment_status_types past
3422: where ass1.assignment_status_type_id = past.assignment_status_type_id
3423: and past.per_system_status = 'TERM_ASSIGN'
3424: and ass1.person_id = ass.person_id
3425: and ass1.assignment_id = ass.assignment_id

Line 3802: FROM per_assignment_status_types

3798: --
3799: hr_utility.set_location(l_proc,14);
3800: SELECT per_system_status
3801: INTO l_per_system_status
3802: FROM per_assignment_status_types
3803: WHERE assignment_status_type_id = c_ass_rec.assignment_status_type_id;
3804: --
3805: --
3806: -- Note the assignment_status_id from the record which ended on ATD