APPS.FUN_NET_ARAP_PKG dependencies on AR_RECEIPT_METHODS

Line 51: payment_type_code ar_receipt_methods.payment_type_code%TYPE);

47: txn_curr_amt ra_customer_trx_lines.extended_amount%TYPE,
48: txn_curr_net_amt fun_net_ar_txns.txn_curr_net_amt%TYPE,
49: net_amt fun_net_ar_txns.netted_amt%TYPE,
50: invoice_currency_code ra_customer_trx.invoice_currency_code%TYPE,
51: payment_type_code ar_receipt_methods.payment_type_code%TYPE);
52:
53: TYPE txnTblType IS TABLE OF txnRecType INDEX BY BINARY_INTEGER;
54: TYPE arReceiptRecType IS RECORD
55: (

Line 70: receipt_method_id ar_receipt_methods.receipt_method_id%TYPE,

66: customer_site_use_id hz_cust_site_uses.site_use_id%TYPE,
67: remittance_bank_account_id fun_net_agreements.bank_account_id%TYPE,
68: remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE,
69: remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE ,
70: receipt_method_id ar_receipt_methods.receipt_method_id%TYPE,
71: org_id fun_net_batches.org_id%TYPE
72: );
73:
74: g_batch_id fun_net_batches_all.batch_id%TYPE;

Line 361: FROM ar_receipt_methods arm

357: WHERE fnar.cust_trx_type_id = rct.cust_trx_type_id
358: AND fnar.agreement_id = :v_agreement_id2)
359: AND NOT EXISTS
360: (SELECT ''X''
361: FROM ar_receipt_methods arm
362: WHERE arm.receipt_method_id = rct.receipt_method_id
363: AND arm.payment_type_code = ''CREDIT_CARD'')
364: AND NOT EXISTS
365: (SELECT ''X''

Line 1915: ar_receipt_methods rm,ar_receipt_method_accounts_ALL rma

1911: begin
1912: select cba.receipt_multi_currency_flag
1913: into l_flag
1914: from ce_bank_accounts cba, ce_bank_acct_uses_ALL ba,ar_receipt_classes rc,
1915: ar_receipt_methods rm,ar_receipt_method_accounts_ALL rma
1916: where rc.creation_method_code = 'NETTING'
1917: and rc.receipt_class_id = rm.receipt_class_id
1918: and ba.bank_account_id = cba.bank_account_id
1919: and rm.receipt_method_id = rma.receipt_method_id

Line 2947: AR_RECEIPT_METHODS arm

2943: FROM FUN_NET_AR_TXNS ftxn,
2944: RA_CUSTOMER_TRX trx,
2945: RA_CUSTOMER_TRX_LINES trx_line,
2946: AR_PAYMENT_SCHEDULES ARPS,
2947: AR_RECEIPT_METHODS arm
2948: WHERE ftxn.customer_trx_id = trx.customer_trx_id
2949: AND trx.customer_trx_id = trx_line.customer_trx_id
2950: AND ARPS.customer_Trx_id = trx.customer_Trx_id
2951: AND ARPS.DUE_DATE <= g_batch_details.TRANSACTION_DUE_DATE

Line 3002: AR_RECEIPT_METHODS arm,

2998: BULK COLLECT INTO txnTable
2999: FROM FUN_NET_AR_TXNS ftxn,
3000: RA_CUSTOMER_TRX trx,
3001: AR_PAYMENT_SCHEDULES ARPS,
3002: AR_RECEIPT_METHODS arm,
3003: RA_CUST_TRX_TYPES ctype
3004: WHERE ftxn.customer_trx_id = trx.customer_trx_id
3005: AND ARPS.customer_Trx_id = trx.customer_Trx_id
3006: AND ARPS.DUE_DATE <= g_batch_details.TRANSACTION_DUE_DATE

Line 3705: l_receipt_method_id ar_receipt_methods.receipt_method_id%TYPE;

3701: x_msg_count OUT NOCOPY NUMBER)
3702: IS
3703:
3704:
3705: l_receipt_method_id ar_receipt_methods.receipt_method_id%TYPE;
3706: l_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;
3707: l_cust_acct_id hz_cust_accounts.cust_account_id%TYPE;
3708: l_cust_site_use_id hz_cust_site_uses.site_use_id%TYPE;
3709: arReceiptRec arReceiptRecType;

Line 3744: FROM ar_receipt_methods

3740: -- Bug 5967665, Changed the where clause to WHERE receipt_method_id= -1
3741: BEGIN
3742: SELECT receipt_method_id
3743: INTO l_receipt_method_id
3744: FROM ar_receipt_methods
3745: WHERE receipt_method_id= -1;
3746:
3747: EXCEPTION
3748: WHEN OTHERS THEN