APPS.WSH_UTIL_VALIDATE dependencies on OE_LOOKUPS

Line 4494: --Cursor to determine whether the given look up code is present in oe lookups.

4490: PROCEDURE validate_freight_terms(
4491: p_freight_terms_code IN VARCHAR2,
4492: x_return_status OUT NOCOPY VARCHAR2 ) IS
4493:
4494: --Cursor to determine whether the given look up code is present in oe lookups.
4495: Cursor c_freight(p_lookup_code VARCHAR2) IS
4496: SELECT '1'
4497: FROM oe_lookups
4498: WHERE

Line 4497: FROM oe_lookups

4493:
4494: --Cursor to determine whether the given look up code is present in oe lookups.
4495: Cursor c_freight(p_lookup_code VARCHAR2) IS
4496: SELECT '1'
4497: FROM oe_lookups
4498: WHERE
4499: lookup_type = 'FREIGHT_TERMS' AND
4500: lookup_code = p_lookup_code AND
4501: nvl(start_date_active,SYSDATE) <= SYSDATE

Line 4552: -- from FND lookups and inserts the same into OE lookups.

4548: OPEN c_freight(p_freight_terms_code);
4549: FETCH c_freight INTO l_fgt;
4550:
4551: -- If true -> the given Freight Term is not in OE lokups. Then it gets the details of the Freight Term
4552: -- from FND lookups and inserts the same into OE lookups.
4553: IF c_freight%NOTFOUND THEN
4554: OPEN c_po_freight(p_freight_terms_code);
4555: FETCH c_po_freight into l_meaning,l_desc;
4556: CLOSE c_po_freight;