APPS.HREMPTER dependencies on PER_ASS_STATUS_TYPE_AMENDS

Line 2690: -- per_ass_status_type_amends table.

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

Line 2696: per_ass_status_type_amends sta

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