DBA Data[Home] [Help]

APPS.JG_JGZZSRCR_XMLP_PKG dependencies on PO_VENDORS

Line 203: APU2 PO_VENDORS.VENDOR_NAME%TYPE;

199:
200: FUNCTION C_VENDOR_NAMEFORMULA RETURN VARCHAR2 IS
201: BEGIN
202: DECLARE
203: APU2 PO_VENDORS.VENDOR_NAME%TYPE;
204: BEGIN
205: SELECT
206: SEGMENT1 || ' ' || VENDOR_NAME
207: INTO APU2

Line 209: PO_VENDORS

205: SELECT
206: SEGMENT1 || ' ' || VENDOR_NAME
207: INTO APU2
208: FROM
209: PO_VENDORS
210: WHERE VENDOR_ID = NVL(P_VENDOR_ID
211: ,-1);
212: RETURN (APU2);
213: EXCEPTION