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 HR_ALL_ORGANIZATION_UNITS_TL

Line 2608: , hr_all_organization_units_tl orgtl

2604: begin
2605: select org.organization_id
2606: into l_organization_id
2607: from hr_all_organization_units org
2608: , hr_all_organization_units_tl orgtl
2609: where orgtl.name = p_organization_name
2610: and orgtl.language = p_language_code
2611: and org.organization_id = orgtl.organization_id
2612: and org.business_group_id + 0 = p_business_group_id;

Line 3255: , hr_all_organization_units_tl orgtl

3251: into l_id
3252: from pay_user_columns puc,
3253: hr_organization_information hoi,
3254: hr_all_organization_units org
3255: , hr_all_organization_units_tl orgtl
3256: where orgtl.name = p_organization_name
3257: and orgtl.language = p_language_code
3258: and org.organization_id = orgtl.organization_id
3259: and org.business_group_id + 0 = p_business_group_id

Line 4040: , hr_all_organization_units_tl orgtl

4036: begin
4037: select org.object_version_number
4038: into l_ovn
4039: from hr_all_organization_units org
4040: , hr_all_organization_units_tl orgtl
4041: where orgtl.name = p_organization_name
4042: and orgtl.language = p_language_code
4043: and org.organization_id = orgtl.organization_id
4044: and org.business_group_id + 0 = p_business_group_id;

Line 5672: , hr_all_organization_units_tl orgtl

5668:
5669: select org.organization_id
5670: into l_organization_id
5671: from hr_all_organization_units org
5672: , hr_all_organization_units_tl orgtl
5673: where orgtl.name = p_parent_organization_name
5674: and orgtl.language = p_language_code
5675: and org.organization_id = orgtl.organization_id
5676: and (org.business_group_id = p_business_group_id

Line 5708: , hr_all_organization_units_tl orgtl

5704: ELSE
5705: select org.organization_id
5706: into l_organization_id
5707: from hr_all_organization_units org
5708: , hr_all_organization_units_tl orgtl
5709: where orgtl.name = p_child_organization_name
5710: and orgtl.language = p_language_code
5711: and org.organization_id = orgtl.organization_id
5712: and (org.business_group_id = p_business_group_id