[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