DBA Data[Home] [Help]

APPS.PO_COMMODITIES_UTIL_PKG dependencies on PO_COMMODITIES_VL

Line 42: l_dup po_commodities_vl.commodity_id%TYPE;

38: , p_comm_name IN VARCHAR2
39: ) RETURN VARCHAR2
40: IS
41:
42: l_dup po_commodities_vl.commodity_id%TYPE;
43:
44: CURSOR po_comm_cur IS
45: SELECT commodity_id
46: FROM po_commodities_vl

Line 46: FROM po_commodities_vl

42: l_dup po_commodities_vl.commodity_id%TYPE;
43:
44: CURSOR po_comm_cur IS
45: SELECT commodity_id
46: FROM po_commodities_vl
47: WHERE commodity_id <> p_comm_id
48: AND upper(name) = upper(p_comm_name);
49:
50: BEGIN