eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PUMP_GET dependencies on PER_ASS_STATUS_TYPE_AMENDS

Line 2575: -- Need to check for amended row in per_ass_status_type_amends first.

2571: p_language_code in varchar2
2572: ) return number is
2573: l_assignment_status_type_id number;
2574: begin
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,

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

Line 2580: per_ass_status_type_amends typ

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
2584: and typtl.LANGUAGE = p_language_code;