DBA Data[Home] [Help]

APPS.AP_PMT_CALLOUT_PKG dependencies on AP_INVOICES_UTILITY_PKG

Line 781: AP_INVOICES_UTILITY_PKG.get_payment_status(inv.invoice_id),

777: SELECT sysdate,
778: p_last_updated_by,
779: iby_amount_paid,
780: iby_discount_amount_taken,
781: AP_INVOICES_UTILITY_PKG.get_payment_status(inv.invoice_id),
782: inv.invoice_id
783: FROM ap_invoices_all inv,
784: ap_selected_invoices_all si,
785: (SELECT sum(ibydocs.payment_amount) iby_amount_paid,

Line 2364: AP_INVOICES_UTILITY_PKG.get_payment_status( inv1.invoice_id )

2360: (SELECT sysdate,
2361: l_last_updated_by,
2362: nvl(inv1.amount_paid,0) + sum(ibydocs.payment_amount),
2363: nvl(inv1.discount_amount_taken,0) + nvl(sum(ibydocs.payment_curr_discount_taken),0),
2364: AP_INVOICES_UTILITY_PKG.get_payment_status( inv1.invoice_id )
2365: FROM iby_fd_docs_payable_v ibydocs,
2366: iby_fd_payments_v ibypmts
2367: WHERE ibypmts.org_type = 'OPERATING_UNIT'
2368: AND ibypmts.payment_id = ibydocs.payment_id