APPS.PO_FED_FIELD_FUNCTIONS dependencies on HR_LOCATIONS_ALL

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 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;