APPS.PAAP_PWP_PKG dependencies on AP_PREPAY_APP_DISTS

Line 938: select sum(dist.amount) prepaid_amount from ap_prepay_app_dists dist, ap_invoice_dIstributions_all apd

934:
935:
936: -- Cursor to get prepaid amount
937: Cursor c_prepay_amt(p_invoice_id Number) is
938: select sum(dist.amount) prepaid_amount from ap_prepay_app_dists dist, ap_invoice_dIstributions_all apd
939: where dist.invoice_distribution_id = apd.invoice_distribution_id
940: and apd.project_id=P_Project_Id
941: and apd.invoice_id=p_invoice_id
942: group by apd.invoice_id;