APPS.FTE_MLS_UTIL dependencies on WSH_LOCATIONS

Line 1341: FROM wsh_locations

1337: CURSOR get_location_cur (c_location_id NUMBER)
1338: IS
1339: SELECT ui_location_code, address1,address2,
1340: address3,city,state,country,postal_code
1341: FROM wsh_locations
1342: WHERE wsh_location_id = c_location_id;
1343:
1344: --}
1345: BEGIN

Line 1614: USE WSH_LOCATIONS

1610: --{
1611:
1612: /**
1613: PACK I -WSH_HR_LOCATION_V SHOULD NOT BE USED
1614: USE WSH_LOCATIONS
1615: CURSOR get_location_cur (c_location_id NUMBER)
1616: IS
1617: SELECT address_line_1,address_line_2,
1618: address_line_3,town_or_city,

Line 1628: FROM wsh_locations

1624: CURSOR get_location_cur (c_location_id NUMBER)
1625: IS
1626: SELECT address1,address2,
1627: address3,city,state,country,postal_code
1628: FROM wsh_locations
1629: WHERE wsh_location_id = c_location_id;
1630:
1631:
1632: --}