DBA Data[Home] [Help]

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