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.ARP_RW_BATCHES_PKG dependencies on CE_BANK_ACCT_USES

Line 450: ce_bank_acct_uses ba

446: AND l_batch_rec.batch_date between rm.start_date and nvl(rm.end_date, l_batch_rec.batch_date)
447: AND EXISTS (SELECT 1
448: FROM ar_receipt_method_accounts rma,
449: ce_bank_accounts cba,
450: ce_bank_acct_uses ba
451: WHERE rma.receipt_method_id = l_batch_rec.receipt_method_id
452: AND rma.remit_bank_acct_use_id = ba.bank_acct_use_id
453: AND cba.bank_account_id = ba.bank_account_id
454: AND cba.currency_code = decode( cba.receipt_multi_currency_flag, 'Y', cba.currency_code,l_batch_rec.currency_code)

Line 888: ce_bank_acct_uses ba

884: WHERE bb.branch_party_id = l_batch_rec.remittance_bank_branch_id
885: AND ( bb.branch_party_id in
886: (SELECT cba.bank_branch_id
887: FROM ce_bank_accounts cba,
888: ce_bank_acct_uses ba
889: WHERE cba.bank_account_id = ba.bank_account_id
890: AND ba.bank_acct_use_id =l_batch_rec.remit_bank_acct_use_id)
891: AND l_batch_rec.remit_bank_acct_use_id is not null)
892: OR (bb.bank_institution_type = 'CLEARING HOUSE'

Line 897: ce_bank_acct_uses ba2,

893: AND l_batch_rec.remit_bank_acct_use_id is null
894: AND EXISTS (SELECT 1
895: FROM ar_receipt_method_accounts rma2,
896: ce_bank_accounts cba2,
897: ce_bank_acct_uses ba2,
898: ce_bank_branches_v bb2,
899: hz_parties CHParty,
900: hz_parties RelParty,
901: hz_relationships BCRel,

Line 927: ce_bank_acct_uses ba,

923:
924: CURSOR c_valid_bank_account IS
925: SELECT ba.bank_acct_use_id
926: FROM ce_bank_accounts cba,
927: ce_bank_acct_uses ba,
928: ce_bank_branches_v br,
929: ar_receipt_method_accounts rma
930: WHERE ba.bank_acct_use_id = l_batch_rec.remit_bank_acct_use_id
931: AND rma.receipt_method_id = nvl(l_batch_rec.receipt_method_id, rma.receipt_method_id)

Line 1437: ce_bank_acct_uses_ou_v ba

1433: l_override_remit_flag
1434: FROM ce_bank_accounts cba,
1435: ce_bank_branches_v bb,
1436: ar_receipt_method_accounts rma,
1437: ce_bank_acct_uses_ou_v ba
1438: WHERE cba.bank_account_id = l_bank_account_id
1439: AND rma.receipt_method_id = l_pay_method_id
1440: AND rma.remit_bank_acct_use_id = ba.bank_acct_use_id
1441: AND cba.bank_account_id = ba.bank_account_id

Line 1489: ce_bank_acct_uses_ou_v ba

1485: rma.receipt_method_id
1486: FROM ce_bank_accounts cba,
1487: ce_bank_branches_v bb,
1488: ar_receipt_method_accounts rma,
1489: ce_bank_acct_uses_ou_v ba
1490: WHERE rma.receipt_method_id = l_pay_method_id
1491: AND rma.remit_bank_acct_use_id = ba.bank_acct_use_id
1492: AND cba.bank_account_id = ba.bank_account_id
1493: AND (cba.currency_code=NVL(l_currency_code,p_currency_code)

Line 1543: ce_bank_acct_uses ba

1539: FROM ar_receipt_methods rm,
1540: ce_bank_accounts cba,
1541: ce_bank_branches_v bb,
1542: ar_receipt_method_accounts rma,
1543: ce_bank_acct_uses ba
1544: WHERE rm.receipt_class_id = l_rec_class_id
1545: AND rm.receipt_method_id = rma.receipt_method_id
1546: AND rma.remit_bank_acct_use_id = ba.bank_acct_use_id
1547: AND cba.bank_account_id = ba.bank_account_id