[Home] [Help]
847: l.postal_code,
848: l.inactive_date
849: FROM
850: wsh_locations l,
851: fnd_territories_tl t
852: WHERE
853: t.territory_code = l.country and
854: t.language = userenv('LANG') and
855: l.wsh_location_id between p_from_location and p_to_location and
868: l.postal_code,
869: l.inactive_date
870: FROM
871: wsh_locations l,
872: fnd_territories_tl t
873: WHERE
874: t.territory_code = l.country and
875: t.language = userenv('LANG') and
876: l.wsh_location_id between p_from_location and p_to_location and
890: l.location_source_code source,
891: l.inactive_date
892: FROM
893: wsh_locations l,
894: fnd_territories_tl t
895: WHERE
896: t.territory_code = l.country and
897: t.language = userenv('LANG') and
898: l.wsh_location_id between p_from_location and p_to_location and
2465: l_location_id NUMBER;
2466: l_wsh_location_id NUMBER;
2467: l_organization_id NUMBER;
2468: map_region BOOLEAN := FALSE;
2469: terr_short_name FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%TYPE;
2470: terr_code FND_TERRITORIES_TL.TERRITORY_CODE%TYPE;
2471: l_region HR_LOCATIONS_ALL.REGION_2%TYPE;
2472: l_city HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE;
2473: l_postal_code HR_LOCATIONS_ALL.POSTAL_CODE%TYPE;
2466: l_wsh_location_id NUMBER;
2467: l_organization_id NUMBER;
2468: map_region BOOLEAN := FALSE;
2469: terr_short_name FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%TYPE;
2470: terr_code FND_TERRITORIES_TL.TERRITORY_CODE%TYPE;
2471: l_region HR_LOCATIONS_ALL.REGION_2%TYPE;
2472: l_city HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE;
2473: l_postal_code HR_LOCATIONS_ALL.POSTAL_CODE%TYPE;
2474: l_location_source VARCHAR2(4);
2488: l.postal_code,
2489: l.inactive_date
2490: FROM
2491: hr_locations_all l,
2492: fnd_territories_tl t
2493: WHERE
2494: t.territory_code = l.country and
2495: t.language = userenv('LANG') and
2496: l.location_id = p_location_id;