DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on PER_ASS_STATUS_TYPE_AMENDS_TL

Line 2579: from per_ass_status_type_amends_tl typtl,

2575: -- Need to check for amended row in per_ass_status_type_amends first.
2576: begin
2577: select typ.assignment_status_type_id
2578: into l_assignment_status_type_id
2579: from per_ass_status_type_amends_tl typtl,
2580: per_ass_status_type_amends typ
2581: where typtl.user_status = p_user_status
2582: and typ.business_group_id + 0 = p_business_group_id
2583: and typ.ass_status_type_amend_id = typtl.ass_status_type_amend_id