APPS.HREMPTER dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 2576: FROM per_assignment_status_types

2572: --
2573: hr_utility.set_location(l_proc,65);
2574: SELECT per_system_status
2575: INTO l_per_system_status
2576: FROM per_assignment_status_types
2577: WHERE assignment_status_type_id = c_ass_rec.assignment_status_type_id;
2578: --
2579: hr_utility.set_location(l_proc,70);
2580: TA_FLAG := (l_per_system_status = 'TERM_ASSIGN' AND

Line 2671: -- both the per_assignment_status_types table and the

2667: -- Terminated Assignment record, and fails because
2668: -- ASSIGNMENT_STATUS_TYPE_ID is mandatory. Fix is to get the default
2669: -- TERM_ASSIGN status immediately before the insert, if one hasn't
2670: -- already been passed in. The code looks for the default status in
2671: -- both the per_assignment_status_types table and the
2672: -- per_ass_status_type_amends table.
2673: --
2674: if p_assignment_status_type_id is null then
2675: select stt.assignment_status_type_id

Line 2677: from per_assignment_status_types stt,

2673: --
2674: if p_assignment_status_type_id is null then
2675: select stt.assignment_status_type_id
2676: into l_assignment_status_type_id
2677: from per_assignment_status_types stt,
2678: per_ass_status_type_amends sta
2679: where nvl(sta.per_system_status,stt.per_system_status) =
2680: 'TERM_ASSIGN'
2681: and stt.assignment_status_type_id =

Line 3684: FROM per_assignment_status_types

3680: --
3681: hr_utility.set_location(l_proc,14);
3682: SELECT per_system_status
3683: INTO l_per_system_status
3684: FROM per_assignment_status_types
3685: WHERE assignment_status_type_id = c_ass_rec.assignment_status_type_id;
3686: --
3687: --
3688: -- Note the assignment_status_id from the record which ended on ATD