APPS.OTA_TDB_BUS2 dependencies on HR_LOCATIONS_ALL

Line 987: hr_locations_all loc

983: loc.country,
984: loc.location_id
985: FROM hr_all_organization_units_tl org,
986: hr_all_organization_units org1,
987: hr_locations_all loc
988: WHERE org.organization_id = org1.organization_id
989: AND loc.location_id(+) = org1.location_id
990: AND org.language = USERENV('LANG')
991: AND org1.organization_id = p_om_org_id;

Line 995: FROM hr_locations_all loc

991: AND org1.organization_id = p_om_org_id;
992:
993: CURSOR evt_country_cr IS
994: SELECT loc.country
995: FROM hr_locations_all loc
996: WHERE loc.location_id = ota_utility.get_event_location(p_event_id);
997: --
998: --
999: l_org_country hr_locations_all.country%TYPE := null;

Line 999: l_org_country hr_locations_all.country%TYPE := null;

995: FROM hr_locations_all loc
996: WHERE loc.location_id = ota_utility.get_event_location(p_event_id);
997: --
998: --
999: l_org_country hr_locations_all.country%TYPE := null;
1000: l_evt_country hr_locations_all.country%TYPE := null;
1001: l_proc VARCHAR2(72) := g_package||'check_location';
1002: --
1003: begin

Line 1000: l_evt_country hr_locations_all.country%TYPE := null;

996: WHERE loc.location_id = ota_utility.get_event_location(p_event_id);
997: --
998: --
999: l_org_country hr_locations_all.country%TYPE := null;
1000: l_evt_country hr_locations_all.country%TYPE := null;
1001: l_proc VARCHAR2(72) := g_package||'check_location';
1002: --
1003: begin
1004: --