APPS.AP_VENDOR_PUB_PKG dependencies on HR_LOCATIONS_ALL_TL

Line 1586: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot

1582:
1583: BEGIN
1584: SELECT lot.location_code
1585: INTO l_ship_locn_code
1586: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot
1587: WHERE loc.location_id = p_ship_location_id
1588: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1589: AND loc.location_id = lot.location_id
1590: AND lot.language = userenv('LANG')

Line 1609: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot

1605: ELSIF (p_ship_location_id is NOT NULL and p_ship_location_code is NOT NULL) THEN
1606: BEGIN
1607: SELECT loc.location_id
1608: INTO l_ship_locn_id
1609: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot
1610: WHERE lot.location_code = p_ship_location_code
1611: AND loc.location_id = p_ship_location_id
1612: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1613: AND loc.location_id = lot.location_id

Line 1634: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot

1630: ELSIF (p_ship_location_id is NULL and p_ship_location_code is NOT NULL) THEN
1631: BEGIN
1632: SELECT loc.location_id
1633: INTO p_ship_location_id
1634: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot
1635: WHERE lot.location_code = p_ship_location_code
1636: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1637: AND loc.location_id = lot.location_id
1638: AND lot.language = userenv('LANG')

Line 1680: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot

1676: ELSIF (p_bill_location_id is NOT NULL and p_bill_location_code is NULL) THEN
1677: BEGIN
1678: SELECT lot.location_code
1679: INTO l_bill_locn_code
1680: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot
1681: WHERE loc.location_id = p_bill_location_id
1682: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1683: AND loc.location_id = lot.location_id
1684: AND lot.language = userenv('LANG')

Line 1704: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot

1700:
1701: BEGIN
1702: SELECT loc.location_id
1703: INTO l_bill_locn_id
1704: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot
1705: WHERE loc.location_id = p_bill_location_id
1706: AND lot.location_code = p_bill_location_code
1707: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1708: AND loc.location_id = lot.location_id

Line 1730: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot

1726:
1727: BEGIN
1728: SELECT loc.location_id
1729: INTO p_bill_location_id
1730: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot
1731: WHERE lot.location_code = p_bill_location_code
1732: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1733: AND loc.location_id = lot.location_id
1734: AND lot.language = userenv('LANG')