APPS.AP_PAY_IN_FULL_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 904: FROM ap_invoice_distributions AID1

900: INTO l_awt_invoices_exists,l_awt_applied --5745239
901: FROM ap_invoices AI
902: WHERE AI.invoice_id = p_invoice_id
903: AND EXISTS (SELECT 'At least 1 dist has an AWT Group'
904: FROM ap_invoice_distributions AID1
905: WHERE AID1.invoice_id = AI.invoice_id
906: AND ( AID1.pay_awt_group_id is not null --Bug6660355
907: OR AID1.awt_group_id is not null)) --Bug7685907
908: AND NOT EXISTS (SELECT 'Manual AWT lines exist'

Line 909: FROM ap_invoice_distributions AID

905: WHERE AID1.invoice_id = AI.invoice_id
906: AND ( AID1.pay_awt_group_id is not null --Bug6660355
907: OR AID1.awt_group_id is not null)) --Bug7685907
908: AND NOT EXISTS (SELECT 'Manual AWT lines exist'
909: FROM ap_invoice_distributions AID
910: WHERE AID.invoice_id = AI.invoice_id
911: AND AID.line_type_lookup_code = 'AWT'
912: AND AID.awt_flag in ('M', 'O'));
913:

Line 928: FROM ap_invoice_distributions

924: end;
925: --Bug6660355
926: SELECT sum(nvl(base_amount,amount))
927: INTO l_total_inv_amount
928: FROM ap_invoice_distributions
929: WHERE invoice_id =p_invoice_id
930: AND line_type_lookup_code <> 'AWT'; /*Bug 14530960*/
931:
932: --Bug7707630: Added NVL condition since the awt_group_id

Line 936: FROM ap_invoice_distributions aid,ap_invoices ai

932: --Bug7707630: Added NVL condition since the awt_group_id
933: --can be null at invoice header level
934: /* SELECT sum(nvl(aid.base_amount,aid.amount)) --query is commented for Bug:14696775
935: INTO l_total_awt_amount
936: FROM ap_invoice_distributions aid,ap_invoices ai
937: WHERE aid.invoice_id =p_invoice_id
938: AND aid.invoice_id = ai.invoice_id
939: AND aid.line_type_lookup_code in ('AWT')
940: AND aid.awt_origin_group_id = NVL(ai.awt_group_id, aid.awt_origin_group_id) --Bug7707630

Line 948: FROM ap_invoice_distributions aid

944:
945: --query is added for Bug:14696775
946: SELECT sum(nvl(aid.base_amount,aid.amount))
947: INTO l_total_awt_amount
948: FROM ap_invoice_distributions aid
949: WHERE aid.invoice_id =p_invoice_id
950: AND aid.line_type_lookup_code in ('AWT')
951: AND aid.awt_invoice_payment_id is null;
952:

Line 1066: FROM ap_invoice_distributions AID,

1062: SELECT nvl(sum(ap_utilities_pkg.ap_round_currency(
1063: AID.amount * AI.payment_cross_rate,
1064: AI.payment_currency_code)),0)
1065: INTO l_withholding_amount
1066: FROM ap_invoice_distributions AID,
1067: ap_invoices AI
1068: WHERE AID.awt_invoice_payment_id = l_invoice_payment_id
1069: AND AID.invoice_id = AI.invoice_id;
1070:

Line 1097: FROM ap_invoice_distributions_all aid,ap_invoice_lines_all ail,ap_invoices_all ai

1093: WHERE aip.invoice_id = p_invoice_id;
1094:
1095: SELECT nvl(SUM(aid.amount),0)
1096: INTO l_prepay_amt
1097: FROM ap_invoice_distributions_all aid,ap_invoice_lines_all ail,ap_invoices_all ai
1098: WHERE ail.invoice_id=aid.invoice_id
1099: AND ail.invoice_id=ai.invoice_id
1100: AND ail.line_number=aid.invoice_line_number
1101: AND ai.invoice_id=p_invoice_id