eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_IREC_PAYMENTS dependencies on CE_BANK_ACCOUNTS

Line 528: ce_bank_accounts cba,

524: FROM ar_receipt_methods arm,
525: ra_cust_receipt_methods rcrm,
526: ar_receipt_method_accounts arma,
527: ce_bank_acct_uses_ou_v aba,
528: ce_bank_accounts cba,
529: ar_receipt_classes arc
530: WHERE arm.receipt_method_id = rcrm.receipt_method_id
531: AND arm.receipt_method_id = arma.receipt_method_id
532: AND arm.receipt_class_id = arc.receipt_class_id

Line 626: ce_bank_accounts cba,

622: arc.creation_status receipt_creation_status
623: FROM ar_receipt_methods arm,
624: ar_receipt_method_accounts arma,
625: ce_bank_acct_uses_ou_v aba,
626: ce_bank_accounts cba,
627: ar_receipt_classes arc
628: WHERE arm.payment_channel_code = 'CREDIT_CARD'
629: AND arm.receipt_method_id = NVL( to_number(fnd_profile.VALUE('OIR_CC_PMT_METHOD')), arm.receipt_method_id)
630: AND arm.receipt_method_id = arma.receipt_method_id

Line 646: ce_bank_accounts cba,

642: arc.creation_status receipt_creation_status
643: FROM ar_receipt_methods arm,
644: ar_receipt_method_accounts arma,
645: ce_bank_acct_uses_ou_v aba,
646: ce_bank_accounts cba,
647: ar_receipt_classes arc
648: WHERE NVL(arm.payment_channel_code,'NONE') <> 'CREDIT_CARD'
649: AND arm.receipt_method_id = NVL( to_number(fnd_profile.VALUE('OIR_BA_PMT_METHOD')), arm.receipt_method_id)
650: AND arm.receipt_method_id = arma.receipt_method_id

Line 1158: p_bank_account_id OUT NOCOPY ce_bank_accounts.bank_account_id%TYPE,

1154: p_account_type OUT NOCOPY VARCHAR2,
1155: p_expiry_month OUT NOCOPY VARCHAR2,
1156: p_expiry_year OUT NOCOPY VARCHAR2,
1157: p_credit_card_expired OUT NOCOPY VARCHAR2,
1158: p_bank_account_id OUT NOCOPY ce_bank_accounts.bank_account_id%TYPE,
1159: p_bank_branch_id OUT NOCOPY ce_bank_accounts.bank_branch_id%TYPE,
1160: p_account_holder OUT NOCOPY VARCHAR2,
1161: p_card_brand OUT NOCOPY VARCHAR2,
1162: p_cvv_code OUT NOCOPY VARCHAR2,

Line 1159: p_bank_branch_id OUT NOCOPY ce_bank_accounts.bank_branch_id%TYPE,

1155: p_expiry_month OUT NOCOPY VARCHAR2,
1156: p_expiry_year OUT NOCOPY VARCHAR2,
1157: p_credit_card_expired OUT NOCOPY VARCHAR2,
1158: p_bank_account_id OUT NOCOPY ce_bank_accounts.bank_account_id%TYPE,
1159: p_bank_branch_id OUT NOCOPY ce_bank_accounts.bank_branch_id%TYPE,
1160: p_account_holder OUT NOCOPY VARCHAR2,
1161: p_card_brand OUT NOCOPY VARCHAR2,
1162: p_cvv_code OUT NOCOPY VARCHAR2,
1163: p_conc_address OUT NOCOPY VARCHAR2,

Line 1386: l_result ce_bank_accounts.bank_account_num%TYPE;

1382:
1383:
1384: l_ba_count NUMBER := 0;
1385: l_cc_count NUMBER := 0;
1386: l_result ce_bank_accounts.bank_account_num%TYPE;
1387: l_payment_instrument VARCHAR2(100);
1388:
1389: x_return_status VARCHAR2(100);
1390: x_cvv_use VARCHAR2(100);

Line 3889: l_bank_branch_id CE_BANK_ACCOUNTS.BANK_BRANCH_ID%TYPE;

3885: l_msg_data VARCHAR2(4000);
3886:
3887: l_call_payment_processor VARCHAR2(1);
3888: l_response_error_code VARCHAR2(80);
3889: l_bank_branch_id CE_BANK_ACCOUNTS.BANK_BRANCH_ID%TYPE;
3890: l_apply_err_count NUMBER;
3891: p_payment_schedule_id NUMBER;
3892:
3893: l_create_credit_card IBY_FNDCPT_SETUP_PUB.CreditCard_rec_type;

Line 5231: ce_bank_accounts cba,

5227: arc.creation_status receipt_creation_status
5228: FROM ar_receipt_methods arm,
5229: ar_receipt_method_accounts arma,
5230: ce_bank_acct_uses_ou_v aba,
5231: ce_bank_accounts cba,
5232: ar_receipt_classes arc
5233: WHERE arm.payment_channel_code = 'CREDIT_CARD'
5234: AND arm.receipt_method_id = NVL( to_number(fnd_profile.VALUE('OIR_CC_PMT_METHOD')), arm.receipt_method_id)
5235: AND arm.receipt_method_id = arma.receipt_method_id

Line 5302: ce_bank_accounts cba,

5298: INTO system_cc_payment_method
5299: FROM ar_system_parameters sp,
5300: ar_receipt_methods rm,
5301: ar_receipt_method_accounts rma,
5302: ce_bank_accounts cba,
5303: ce_bank_acct_uses_ou_v ba,
5304: ar_receipt_classes rc
5305: WHERE sp.irec_cc_receipt_method_id = rm.receipt_method_id
5306: AND rma.receipt_method_id = rm.receipt_method_id

Line 5331: ce_bank_accounts cba,

5327: FROM ar_receipt_methods arm,
5328: ra_cust_receipt_methods rcrm,
5329: ar_receipt_method_accounts arma,
5330: ce_bank_acct_uses_ou_v aba,
5331: ce_bank_accounts cba,
5332: ar_receipt_classes arc
5333: WHERE arm.receipt_method_id = rcrm.receipt_method_id
5334: AND arm.receipt_method_id = arma.receipt_method_id
5335: AND arm.receipt_class_id = arc.receipt_class_id

Line 5418: ce_bank_accounts cba,

5414: arc.creation_status receipt_creation_status
5415: FROM ar_receipt_methods arm,
5416: ar_receipt_method_accounts arma,
5417: ce_bank_acct_uses_ou_v aba,
5418: ce_bank_accounts cba,
5419: ar_receipt_classes arc
5420: WHERE NVL(arm.payment_channel_code,'NONE') <> 'CREDIT_CARD'
5421: AND arm.receipt_method_id = NVL( to_number(fnd_profile.VALUE('OIR_BA_PMT_METHOD')), arm.receipt_method_id)
5422: AND arm.receipt_method_id = arma.receipt_method_id

Line 5488: ce_bank_accounts cba

5484: FROM ar_system_parameters sp,
5485: ar_receipt_methods rm,
5486: ar_receipt_method_accounts rma,
5487: ce_bank_acct_uses_ou_v ba,
5488: ce_bank_accounts cba
5489: WHERE sp.irec_ba_receipt_method_id = rm.receipt_method_id
5490: AND rma.receipt_method_id = rm.receipt_method_id
5491: AND rma.remit_bank_acct_use_id = ba.bank_acct_use_id
5492: AND ba.bank_account_id = cba.bank_account_id

Line 5507: ce_bank_accounts cba,

5503: FROM ar_receipt_methods arm,
5504: ra_cust_receipt_methods rcrm,
5505: ar_receipt_method_accounts arma,
5506: ce_bank_acct_uses_ou_v aba,
5507: ce_bank_accounts cba,
5508: ar_receipt_classes arc
5509: WHERE arm.receipt_method_id = rcrm.receipt_method_id
5510: AND arm.receipt_method_id = arma.receipt_method_id
5511: AND arm.receipt_class_id = arc.receipt_class_id