APPS.JG_ZZ_SUMMARY_AP_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL
Line 52: FROM ap_invoice_distributions_all apid
48:
49: CURSOR c_prepay_inv_amount
50: IS
51: SELECT ABS(NVL(SUM(apid.amount), 0)) prepay_on_inv_amt 52: FROM ap_invoice_distributions_all apid 53: WHERE PREPAY_DISTRIBUTION_ID IS NOT NULL
54: AND invoice_id = pn_inv_id;
55:
56: CURSOR c_inv_amount