APPS.WSH_UTIL_VALIDATE dependencies on OE_LOOKUPS

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

4446: PROCEDURE validate_freight_terms(
4447: p_freight_terms_code IN VARCHAR2,
4448: x_return_status OUT NOCOPY VARCHAR2 ) IS
4449:
4450: --Cursor to determine whether the given look up code is present in oe lookups.
4451: Cursor c_freight(p_lookup_code VARCHAR2) IS
4452: SELECT '1'
4453: FROM oe_lookups
4454: WHERE

Line 4453: FROM oe_lookups

4449:
4450: --Cursor to determine whether the given look up code is present in oe lookups.
4451: Cursor c_freight(p_lookup_code VARCHAR2) IS
4452: SELECT '1'
4453: FROM oe_lookups
4454: WHERE
4455: lookup_type = 'FREIGHT_TERMS' AND
4456: lookup_code = p_lookup_code AND
4457: nvl(start_date_active,SYSDATE) <= SYSDATE

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

4504: OPEN c_freight(p_freight_terms_code);
4505: FETCH c_freight INTO l_fgt;
4506:
4507: -- If true -> the given Freight Term is not in OE lokups. Then it gets the details of the Freight Term
4508: -- from FND lookups and inserts the same into OE lookups.
4509: IF c_freight%NOTFOUND THEN
4510: OPEN c_po_freight(p_freight_terms_code);
4511: FETCH c_po_freight into l_meaning,l_desc;
4512: CLOSE c_po_freight;