DBA Data[Home] [Help]

APPS.AP_PMT_CALLOUT_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 190: FROM ap_invoice_payments_all aip,

186:
187:
188: CURSOR C_INTEREST_INVOICES IS
189: SELECT i.invoice_id
190: FROM ap_invoice_payments_all aip,
191: ap_checks_all c,
192: ap_invoices_all i,
193: ap_invoice_relationships ir
194: WHERE c.check_id = p_check_id

Line 858: AP_Invoice_Payments_All AIP,

854: CURSOR c_subscribed_payments IS
855: SELECT Distinct AC.Check_ID,
856: APR.Reg_Application_ID
857: FROM AP_Checks_All AC,
858: AP_Invoice_Payments_All AIP,
859: AP_Invoices_All AI,
860: AP_Product_Registrations APR
861: WHERE AC.Checkrun_Name = l_checkrun_name
862: AND AC.Completed_Pmts_Group_ID = p_completed_pmts_group_id

Line 1013: from ap_invoice_payments_all ip

1009: where ifd.payment_id = ifp.payment_id (+)
1010: and ifd.completed_pmts_group_id = p_completed_pmts_group_id
1011: and not exists
1012: (select 1
1013: from ap_invoice_payments_all ip
1014: , ap_checks_all c
1015: where c.payment_id = ifd.payment_id
1016: and c.completed_pmts_group_id = ifd.completed_pmts_group_id
1017: and c.check_id = ip.check_id

Line 1036: from ap_invoice_payments_all ip

1032: CURSOR c_prob_inv_pmts IS
1033: select ifp.payment_id, ifp.payment_reference_number
1034: , ifp.payment_instruction_id, TO_CHAR(ip.invoice_id), TO_CHAR(ip.payment_num)
1035: , 'AP_INV_PAY'
1036: from ap_invoice_payments_all ip
1037: , ap_checks_all c
1038: , iby_fd_payments_v ifp
1039: where ip.check_id = c.check_id
1040: and ifp.payment_id = c.payment_id

Line 2129: l_debug_info := 'insert into ap_invoice_payments_all';

2125: CLOSE c_invoice_amounts; --Bug5733731
2126:
2127:
2128:
2129: l_debug_info := 'insert into ap_invoice_payments_all';
2130: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2131: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2132: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2133: END IF;

Line 2135: INSERT INTO ap_invoice_payments_all(

2131: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2132: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2133: END IF;
2134:
2135: INSERT INTO ap_invoice_payments_all(
2136: INVOICE_PAYMENT_ID,
2137: INVOICE_ID,
2138: PAYMENT_NUM,
2139: CHECK_ID,

Line 2418: p_key_table => 'AP_INVOICE_PAYMENTS_ALL',

2414: END IF;
2415: AP_DBI_PKG.Insert_Payment_Confirm_DBI(
2416: p_checkrun_name => l_checkrun_name,
2417: p_base_currency_code => l_base_currency_code,
2418: p_key_table => 'AP_INVOICE_PAYMENTS_ALL',
2419: p_calling_sequence => l_current_calling_sequence );
2420:
2421: l_debug_info := 'AP_Accounting_Events_Pkg.Batch_Update_Payment_Info';
2422: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);

Line 3221: ap_invoice_payments_all aip,

3217: if(l_payment_status in ('ISSUED','NEGOTIABLE','STOP INITIATED')) then
3218:
3219: SELECT COUNT(*) INTO l_prepay_app_exists
3220: FROM ap_checks_all ac,
3221: ap_invoice_payments_all aip,
3222: ap_invoice_distributions_all aid,
3223: ap_invoices_all ai
3224: WHERE ac.payment_id = p_payment_id
3225: AND ac.check_id = aip.check_id

Line 3249: ap_invoice_payments_all aip,

3245: WHERE EXISTS
3246: (SELECT 1
3247: FROM ap_invoice_distributions_all aid_prepay,
3248: ap_checks_all ac,
3249: ap_invoice_payments_all aip,
3250: ap_invoices_all ai_prepay,
3251: ap_invoice_distributions_all aid,
3252: ap_invoice_distributions_all aidp
3253: WHERE aip.check_id = ac.check_id