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 451: ce_bank_acct_uses ba

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

Line 889: ce_bank_acct_uses ba

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

Line 898: ce_bank_acct_uses ba2,

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

Line 928: ce_bank_acct_uses ba,

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

Line 1438: ce_bank_acct_uses_ou_v ba

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

Line 1490: ce_bank_acct_uses_ou_v ba

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

Line 1544: ce_bank_acct_uses ba

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