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 1041: from hr_locations_all loc

1037: is
1038:
1039: cursor csr_location_legal_adr is
1040: select 'Y'
1041: from hr_locations_all loc
1042: where loc.location_id = p_location_id
1043: and nvl(loc.legal_address_flag,'N') = 'Y';
1044:
1045: l_exists varchar2(1);

Line 1266: ,hr_locations_all loc

1262: ,per.business_group_id bg_id
1263: FROM per_all_people_f per
1264: ,per_all_assignments_f ass
1265: ,per_business_groups_perf bg
1266: ,hr_locations_all loc
1267: ,hr_all_organization_units org
1268: ,per_addresses adr
1269: WHERE ass.person_id(+) = per.person_id
1270: AND NVL(ass.primary_flag(+),'Y') = 'Y'

Line 1592: ,hr_locations_all_tl loc

1588: per.business_group_id "BusinessGroupId"
1589: from per_all_people_f per
1590: ,per_all_assignments_f ass
1591: ,hr_all_organization_units_tl bg
1592: ,hr_locations_all_tl loc
1593: ,hr_all_organization_units_tl org
1594: ,per_addresses adr
1595: where ass.person_id(+) = per.person_id
1596: and ass.primary_flag(+) = 'Y'

Line 1694: ,hr_locations_all loc

1690: ,per.business_group_id "BusinessGroupId"
1691: FROM per_all_people_f per
1692: ,per_all_assignments_f ass
1693: ,per_business_groups_perf bg
1694: ,hr_locations_all loc
1695: ,hr_all_organization_units org
1696: ,per_addresses adr
1697: WHERE ass.person_id(+) = per.person_id
1698: AND NVL(ass.primary_flag(+),'Y') = 'Y'