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_PERSON_TYPES

Line 2507: from per_person_types_tl typtl,

2503: l_person_type_id number;
2504: begin
2505: select typ.person_type_id
2506: into l_person_type_id
2507: from per_person_types_tl typtl,
2508: per_person_types typ
2509: where typtl.user_person_type = p_user_person_type
2510: and typ.business_group_id + 0 = p_business_group_id
2511: and typ.person_type_id = typtl.person_type_id

Line 2508: per_person_types typ

2504: begin
2505: select typ.person_type_id
2506: into l_person_type_id
2507: from per_person_types_tl typtl,
2508: per_person_types typ
2509: where typtl.user_person_type = p_user_person_type
2510: and typ.business_group_id + 0 = p_business_group_id
2511: and typ.person_type_id = typtl.person_type_id
2512: and typtl.LANGUAGE = p_language_code;

Line 2534: from per_person_types_tl typtl,

2530: l_person_type_id number;
2531: begin
2532: select typ.person_type_id
2533: into l_person_type_id
2534: from per_person_types_tl typtl,
2535: per_person_types typ
2536: where typtl.user_person_type = p_user_person_type
2537: and typ.business_group_id + 0 = p_business_group_id
2538: and typ.person_type_id = typtl.person_type_id

Line 2535: per_person_types typ

2531: begin
2532: select typ.person_type_id
2533: into l_person_type_id
2534: from per_person_types_tl typtl,
2535: per_person_types typ
2536: where typtl.user_person_type = p_user_person_type
2537: and typ.business_group_id + 0 = p_business_group_id
2538: and typ.person_type_id = typtl.person_type_id
2539: and typtl.LANGUAGE = p_language_code;