DBA Data[Home] [Help]

APPS.AP_PMT_CALLOUT_PKG dependencies on AP_INVOICES_UTILITY_PKG

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

874: SELECT sysdate,
875: p_last_updated_by,
876: iby_amount_paid,
877: iby_discount_amount_taken,
878: AP_INVOICES_UTILITY_PKG.get_payment_status(inv.invoice_id),
879: inv.invoice_id
880: FROM ap_invoices_all inv,
881: ap_selected_invoices_all si,
882: (SELECT sum(ibydocs.payment_amount) iby_amount_paid,

Line 2578: AP_INVOICES_UTILITY_PKG.get_payment_status( inv1.invoice_id )

2574: (SELECT sysdate,
2575: l_last_updated_by,
2576: nvl(inv1.amount_paid,0) + sum(ibydocs.payment_amount),
2577: nvl(inv1.discount_amount_taken,0) + nvl(sum(ibydocs.payment_curr_discount_taken),0),
2578: AP_INVOICES_UTILITY_PKG.get_payment_status( inv1.invoice_id )
2579: FROM iby_fd_docs_payable_v ibydocs,
2580: iby_fd_payments_v ibypmts
2581: WHERE ibypmts.org_type = 'OPERATING_UNIT'
2582: AND ibypmts.payment_id = ibydocs.payment_id