APPS.HREMPTER dependencies on PER_ASS_STATUS_TYPE_AMENDS

Line 2672: -- per_ass_status_type_amends table.

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
2676: into l_assignment_status_type_id

Line 2678: per_ass_status_type_amends sta

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 =
2682: sta.assignment_status_type_id (+)