DBA Data[Home] [Help]

APPS.JE_JEFILPIP_XMLP_PKG dependencies on PO_VENDORS

Line 181: APU2 PO_VENDORS.VENDOR_NAME%TYPE;

177:
178: FUNCTION C_VENDOR_NAMEFORMULA RETURN VARCHAR2 IS
179: BEGIN
180: DECLARE
181: APU2 PO_VENDORS.VENDOR_NAME%TYPE;
182: BEGIN
183: SELECT
184: SEGMENT1 || ' ' || VENDOR_NAME
185: INTO APU2

Line 187: PO_VENDORS

183: SELECT
184: SEGMENT1 || ' ' || VENDOR_NAME
185: INTO APU2
186: FROM
187: PO_VENDORS
188: WHERE VENDOR_ID = NVL(P_VENDOR_ID
189: ,-1);
190: RETURN (APU2);
191: EXCEPTION