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_GENERAL2 dependencies on HR_LOCATIONS_ALL

Line 1095: from hr_locations_all loc

1091: is
1092:
1093: cursor csr_location_legal_adr is
1094: select 'Y'
1095: from hr_locations_all loc
1096: where loc.location_id = p_location_id
1097: and nvl(loc.legal_address_flag,'N') = 'Y';
1098:
1099: l_exists varchar2(1);

Line 1320: ,hr_locations_all loc

1316: ,per.business_group_id bg_id
1317: FROM per_all_people_f per
1318: ,per_all_assignments_f ass
1319: ,per_business_groups_perf bg
1320: ,hr_locations_all loc
1321: ,hr_all_organization_units org
1322: ,per_addresses adr
1323: WHERE ass.person_id(+) = per.person_id
1324: AND NVL(ass.primary_flag(+),'Y') = 'Y'

Line 1647: ,hr_locations_all_tl loc

1643: per.business_group_id "BusinessGroupId"
1644: from per_all_people_f per
1645: ,per_all_assignments_f ass
1646: ,hr_all_organization_units_tl bg
1647: ,hr_locations_all_tl loc
1648: ,hr_all_organization_units_tl org
1649: ,per_addresses adr
1650: where ass.person_id(+) = per.person_id
1651: and ass.primary_flag(+) = 'Y'

Line 1749: ,hr_locations_all loc

1745: ,per.business_group_id "BusinessGroupId"
1746: FROM per_all_people_f per
1747: ,per_all_assignments_f ass
1748: ,per_business_groups_perf bg
1749: ,hr_locations_all loc
1750: ,hr_all_organization_units org
1751: ,per_addresses adr
1752: WHERE ass.person_id(+) = per.person_id
1753: AND NVL(ass.primary_flag(+),'Y') = 'Y'