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 2548: -- Need to check for amended row in per_ass_status_type_amends first.

2544: p_language_code in varchar2
2545: ) return number is
2546: l_assignment_status_type_id number;
2547: begin
2548: -- Need to check for amended row in per_ass_status_type_amends first.
2549: begin
2550: select typ.assignment_status_type_id
2551: into l_assignment_status_type_id
2552: from per_ass_status_type_amends_tl typtl,

Line 2552: from per_ass_status_type_amends_tl typtl,

2548: -- Need to check for amended row in per_ass_status_type_amends first.
2549: begin
2550: select typ.assignment_status_type_id
2551: into l_assignment_status_type_id
2552: from per_ass_status_type_amends_tl typtl,
2553: per_ass_status_type_amends typ
2554: where typtl.user_status = p_user_status
2555: and typ.business_group_id + 0 = p_business_group_id
2556: and typ.ass_status_type_amend_id = typtl.ass_status_type_amend_id

Line 2553: per_ass_status_type_amends typ

2549: begin
2550: select typ.assignment_status_type_id
2551: into l_assignment_status_type_id
2552: from per_ass_status_type_amends_tl typtl,
2553: per_ass_status_type_amends typ
2554: where typtl.user_status = p_user_status
2555: and typ.business_group_id + 0 = p_business_group_id
2556: and typ.ass_status_type_amend_id = typtl.ass_status_type_amend_id
2557: and typtl.LANGUAGE = p_language_code;