APPS.JA_JAINITCP_XMLP_PKG dependencies on PO_VENDOR_SITES_ALL

Line 57: PO_VENDOR_SITES_ALL POVS,

53: AP_INVOICE_PAYMENTS_ALL APIP,
54: PO_VENDORS POV1,
55: PO_VENDORS POV2,
56: PO_VENDORS POV3,
57: PO_VENDOR_SITES_ALL POVS,
58: AP_INVOICE_LINES_ALL APLA
59: WHERE DECODE(AFRM.ORG_ID
60: ,NULL
61: ,0

Line 215: PO_VENDOR_SITES_ALL POVS

211: CURSOR C_VEND_SITE_ADDR IS
212: SELECT
213: POVS.ADDRESS_LINE1 || ',' || POVS.ADDRESS_LINE2 || ',' || POVS.ADDRESS_LINE3 || ',' || POVS.CITY || ',' || POVS.STATE || ',' || POVS.ZIP || ',' || POVS.COUNTRY VENDOR_SITE_ADDRESS
214: FROM
215: PO_VENDOR_SITES_ALL POVS
216: WHERE VENDOR_SITE_ID = VENDOR_SITE_ID_V;
217: V_VENDOR_SITE_ADDR VARCHAR2(500);
218: BEGIN
219: OPEN C_VEND_SITE_ADDR;