APPS.JA_CN_CUSTOM_SOURCES dependencies on AP_INVOICES_ALL

Line 65: FROM AP_INVOICES_ALL aia

61: END IF; --(l_proc_level >= l_dbg_level)
62:
63: SELECT 'Refund'
64: INTO l_refund_item
65: FROM AP_INVOICES_ALL aia
66: WHERE aia.INVOICE_ID = P_INVOICE_ID
67: and aia.PAY_PROC_TRXN_TYPE_CODE='AR_CUSTOMER_REFUND'
68: and aia.INVOICE_TYPE_LOOKUP_CODE = 'PAYMENT REQUEST';
69:

Line 142: FROM AP_INVOICES_ALL

138: --THEN GET THE VALUE FROM HEADER.
139: IF GDF_ITEM IS NULL THEN
140: SELECT GLOBAL_ATTRIBUTE1
141: INTO GDF_ITEM
142: FROM AP_INVOICES_ALL
143: WHERE INVOICE_ID=P_INVOICE_ID;
144: END IF;
145:
146: RETURN GDF_ITEM;

Line 670: FROM ap_invoice_payments_all apa, AP_INVOICES_ALL aia

666:
667:
668: SELECT apa.invoice_id, aia.source
669: INTO ln_invoice_id, lv_invoice_source
670: FROM ap_invoice_payments_all apa, AP_INVOICES_ALL aia
671: WHERE apa.invoice_payment_id = p_invoice_payment_id
672: AND aia.invoice_id = apa.invoice_id;
673:
674: CASE lv_invoice_source