DBA Data[Home] [Help]

APPS.JA_JAINAPCR_XMLP_PKG dependencies on PO_VENDORS

Line 252: PO_VENDORS

248: SELECT
249: VENDOR_ID
250: INTO V_VENDOR_ID
251: FROM
252: PO_VENDORS
253: WHERE SEGMENT1 = V_SEGMENT2;
254: SELECT
255: SET_OF_BOOKS_ID
256: INTO V_SET_OF_BOOKS_ID

Line 295: PO_VENDORS

291: SELECT
292: VENDOR_ID
293: INTO V_VENDOR_ID
294: FROM
295: PO_VENDORS
296: WHERE SEGMENT1 = V_SEGMENT2;
297: SELECT
298: SET_OF_BOOKS_ID
299: INTO V_SET_OF_BOOKS_ID

Line 326: PO_VENDORS

322: CURSOR FOR_NAME(V_ID IN NUMBER,V_NO IN VARCHAR2) IS
323: SELECT
324: VENDOR_NAME
325: FROM
326: PO_VENDORS
327: WHERE VENDOR_ID = V_ID
328: OR SEGMENT1 = V_NO;
329: V_VENDOR_NAME VARCHAR2(80);
330: BEGIN