APPS.PO_FED_FIELD_FUNCTIONS dependencies on HR_LOCATIONS

Line 257: FROM HR_LOCATIONS_ALL

253: SELECT LOCATION_CODE,ADDRESS_LINE_1,ADDRESS_LINE_2,ADDRESS_LINE_3,TOWN_OR_CITY,REGION_1,
254: REGION_2,REGION_3,TELEPHONE_NUMBER_1,TELEPHONE_NUMBER_2,POSTAL_CODE,COUNTRY
255: INTO l_LOCATION_CODE,l_ADDRESS_LINE_1,l_ADDRESS_LINE_2,l_ADDRESS_LINE_3,l_TOWN_OR_CITY,l_REGION_1,
256: l_REGION_2,l_REGION_3,l_TELEPHONE_NUMBER_1,l_TELEPHONE_NUMBER_2,l_POSTAL_CODE,l_COUNTRY
257: FROM HR_LOCATIONS_ALL
258: WHERE LOCATION_ID = location;
259:
260: hiddenCountry := l_REGION_2;
261: hiddenZipCode := l_POSTAL_CODE;

Line 1364: FROM HR_LOCATIONS

1360: IF x_ship_to_addr IS NULL THEN
1361:
1362: SELECT ADDRESS_LINE_1, ADDRESS_LINE_2, TOWN_OR_CITY, REGION_2, STYLE, POSTAL_CODE,COUNTRY
1363: INTO l_addr_line_1, l_addr_line_2, l_town_or_city, l_region2, l_style, l_postal_code,p_hiddenCountry
1364: FROM HR_LOCATIONS
1365: WHERE LOCATION_ID = p_ship_to_loc_id;
1366:
1367: l_state := l_region2;
1368:

Line 1399: FROM HR_LOCATIONS HLC,

1395: hlc.region_2, fcl2.meaning region2_desc,
1396: HLC.COUNTRY, NVL(FTE.TERRITORY_SHORT_NAME,HLC.COUNTRY) country_name,
1397: hlc.postal_code,
1398: HLC.TELEPHONE_NUMBER_1 contact_phone, HLC.TELEPHONE_NUMBER_2 contact_fax).getStringVal()
1399: FROM HR_LOCATIONS HLC,
1400: FND_TERRITORIES_TL FTE,
1401: FND_LOOKUP_VALUES FCL1,
1402: FND_LOOKUP_VALUES FCL2,
1403: FND_LOOKUP_VALUES FCL3

Line 1482: FROM HR_LOCATIONS

1478: IF ( p_ship_to_loc_id IS NOT NULL ) THEN
1479:
1480: SELECT ADDRESS_LINE_1, ADDRESS_LINE_2, TOWN_OR_CITY, REGION_2, STYLE, POSTAL_CODE,COUNTRY
1481: INTO l_addr_line_1, l_addr_line_2, l_town_or_city, l_region2, l_style, l_postal_code,p_hiddenCountry
1482: FROM HR_LOCATIONS
1483: WHERE LOCATION_ID = p_ship_to_loc_id;
1484:
1485: l_state := l_region2;
1486:

Line 1517: FROM HR_LOCATIONS HLC,

1513: hlc.region_2, fcl2.meaning region2_desc,
1514: HLC.COUNTRY, NVL(FTE.TERRITORY_SHORT_NAME,HLC.COUNTRY) country_name,
1515: hlc.postal_code,
1516: HLC.TELEPHONE_NUMBER_1 contact_phone, HLC.TELEPHONE_NUMBER_2 contact_fax).getStringVal()
1517: FROM HR_LOCATIONS HLC,
1518: FND_TERRITORIES_TL FTE,
1519: FND_LOOKUP_VALUES FCL1,
1520: FND_LOOKUP_VALUES FCL2,
1521: FND_LOOKUP_VALUES FCL3

Line 3103: FROM HR_LOCATIONS

3099: WHERE LINE_LOCATION_ID = p_line_loc_id;
3100:
3101: SELECT ADDRESS_LINE_1, ADDRESS_LINE_2, TOWN_OR_CITY, REGION_2, STYLE, POSTAL_CODE,COUNTRY
3102: INTO l_addr_line_1, l_addr_line_2, l_town_or_city, l_region2, l_style, l_postal_code,p_hiddenCountry
3103: FROM HR_LOCATIONS
3104: WHERE LOCATION_ID = l_ship_to_loc_id;
3105:
3106: l_state := l_region2;
3107:

Line 3138: FROM HR_LOCATIONS HLC,

3134: hlc.region_2, fcl2.meaning region2_desc,
3135: HLC.COUNTRY, NVL(FTE.TERRITORY_SHORT_NAME,HLC.COUNTRY) country_name,
3136: hlc.postal_code,
3137: HLC.TELEPHONE_NUMBER_1 contact_phone, HLC.TELEPHONE_NUMBER_2 contact_fax).getStringVal()
3138: FROM HR_LOCATIONS HLC,
3139: FND_TERRITORIES_TL FTE,
3140: FND_LOOKUP_VALUES FCL1,
3141: FND_LOOKUP_VALUES FCL2,
3142: FND_LOOKUP_VALUES FCL3

Line 3459: FROM HR_LOCATIONS_ALL

3455: SELECT LOCATION_CODE,ADDRESS_LINE_1,ADDRESS_LINE_2,ADDRESS_LINE_3,TOWN_OR_CITY,REGION_1,
3456: REGION_2,REGION_3,TELEPHONE_NUMBER_1,TELEPHONE_NUMBER_2,POSTAL_CODE,COUNTRY
3457: INTO l_LOCATION_CODE,l_ADDRESS_LINE_1,l_ADDRESS_LINE_2,l_ADDRESS_LINE_3,l_TOWN_OR_CITY,l_REGION_1,
3458: l_REGION_2,l_REGION_3,l_TELEPHONE_NUMBER_1,l_TELEPHONE_NUMBER_2,l_POSTAL_CODE,l_COUNTRY
3459: FROM HR_LOCATIONS_ALL
3460: WHERE LOCATION_ID = p_insp_location;
3461:
3462: IF l_ADDRESS_LINE_1 IS NOT NULL THEN
3463: p_insp_addressdetails := l_ADDRESS_LINE_1 || newline;

Line 3496: FROM HR_LOCATIONS_ALL

3492: SELECT LOCATION_CODE,ADDRESS_LINE_1,ADDRESS_LINE_2,ADDRESS_LINE_3,TOWN_OR_CITY,REGION_1,
3493: REGION_2,REGION_3,TELEPHONE_NUMBER_1,TELEPHONE_NUMBER_2,POSTAL_CODE,COUNTRY
3494: INTO l_LOCATION_CODE,l_ADDRESS_LINE_1,l_ADDRESS_LINE_2,l_ADDRESS_LINE_3,l_TOWN_OR_CITY,l_REGION_1,
3495: l_REGION_2,l_REGION_3,l_TELEPHONE_NUMBER_1,l_TELEPHONE_NUMBER_2,l_POSTAL_CODE,l_COUNTRY
3496: FROM HR_LOCATIONS_ALL
3497: WHERE LOCATION_ID = p_accp_location;
3498:
3499: IF l_ADDRESS_LINE_1 IS NOT NULL THEN
3500: p_accp_addressdetails := l_ADDRESS_LINE_1 || newline;