APPS.AP_PAY_IN_FULL_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 848: FROM ap_invoice_distributions AID1

844: INTO l_awt_invoices_exists,l_awt_applied --5745239
845: FROM ap_invoices AI
846: WHERE AI.invoice_id = p_invoice_id
847: AND EXISTS (SELECT 'At least 1 dist has an AWT Group'
848: FROM ap_invoice_distributions AID1
849: WHERE AID1.invoice_id = AI.invoice_id
850: AND AID1.pay_awt_group_id is not null --Bug6660355
851: OR AID1.awt_group_id is not null) --Bug7685907
852: AND NOT EXISTS (SELECT 'Manual AWT lines exist'

Line 853: FROM ap_invoice_distributions AID

849: WHERE AID1.invoice_id = AI.invoice_id
850: AND AID1.pay_awt_group_id is not null --Bug6660355
851: OR AID1.awt_group_id is not null) --Bug7685907
852: AND NOT EXISTS (SELECT 'Manual AWT lines exist'
853: FROM ap_invoice_distributions AID
854: WHERE AID.invoice_id = AI.invoice_id
855: AND AID.line_type_lookup_code = 'AWT'
856: AND AID.awt_flag in ('M', 'O'));
857:

Line 872: FROM ap_invoice_distributions

868: end;
869: --Bug6660355
870: SELECT sum(nvl(base_amount,amount))
871: INTO l_total_inv_amount
872: FROM ap_invoice_distributions
873: WHERE invoice_id =p_invoice_id
874: AND line_type_lookup_code not in('PREPAYMENT','AWT');
875:
876: SELECT sum(nvl(aid.base_amount,aid.amount))

Line 878: FROM ap_invoice_distributions aid,ap_invoices ai

874: AND line_type_lookup_code not in('PREPAYMENT','AWT');
875:
876: SELECT sum(nvl(aid.base_amount,aid.amount))
877: INTO l_total_awt_amount
878: FROM ap_invoice_distributions aid,ap_invoices ai
879: WHERE aid.invoice_id =p_invoice_id
880: AND aid.invoice_id = ai.invoice_id
881: AND aid.line_type_lookup_code in ('AWT')
882: AND aid.awt_origin_group_id = ai.awt_group_id;

Line 960: FROM ap_invoice_distributions AID,

956: SELECT nvl(sum(ap_utilities_pkg.ap_round_currency(
957: AID.amount * AI.payment_cross_rate,
958: AI.payment_currency_code)),0)
959: INTO l_withholding_amount
960: FROM ap_invoice_distributions AID,
961: ap_invoices AI
962: WHERE AID.awt_invoice_payment_id = l_invoice_payment_id
963: AND AID.invoice_id = AI.invoice_id;
964: