APPS.JA_JAINPROS_XMLP_PKG dependencies on PO_VENDORS

Line 111: PO_VENDORS

107: CURSOR C_VENDOR_NAME(P_VENDOR_ID IN NUMBER) IS
108: SELECT
109: VENDOR_NAME
110: FROM
111: PO_VENDORS
112: WHERE VENDOR_ID = P_VENDOR_ID;
113: V_VENDOR_NAME PO_VENDORS.VENDOR_NAME%TYPE;
114: BEGIN
115: OPEN C_VENDOR_NAME(VENDOR_ID);

Line 113: V_VENDOR_NAME PO_VENDORS.VENDOR_NAME%TYPE;

109: VENDOR_NAME
110: FROM
111: PO_VENDORS
112: WHERE VENDOR_ID = P_VENDOR_ID;
113: V_VENDOR_NAME PO_VENDORS.VENDOR_NAME%TYPE;
114: BEGIN
115: OPEN C_VENDOR_NAME(VENDOR_ID);
116: FETCH C_VENDOR_NAME
117: INTO V_VENDOR_NAME;