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_ACCOUNTS

Line 450: ce_bank_accounts cba,

446: AND rm.receipt_class_id = l_batch_rec.receipt_class_id
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

Line 888: FROM ce_bank_accounts cba,

884: FROM ce_bank_branches_v bb
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)

Line 897: ce_bank_accounts cba2,

893: OR (bb.bank_institution_type = 'CLEARING HOUSE'
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,

Line 927: FROM ce_bank_accounts cba,

923: AND CHParty.party_id = bb.branch_party_id));
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

Line 1284: p_bank_account_num OUT NOCOPY ce_bank_accounts.bank_account_num%TYPE,

1280: p_rec_class_name OUT NOCOPY ar_receipt_classes.name%TYPE,
1281: p_pay_method_id OUT NOCOPY ar_receipt_methods.receipt_method_id%TYPE,
1282: p_pay_method_name OUT NOCOPY ar_receipt_methods.name%TYPE,
1283: p_bank_name OUT NOCOPY ce_bank_branches_v.bank_name%TYPE,
1284: p_bank_account_num OUT NOCOPY ce_bank_accounts.bank_account_num%TYPE,
1285: p_bank_account_id OUT NOCOPY ce_bank_accounts.bank_account_id%TYPE,
1286: p_currency_code IN OUT NOCOPY ce_bank_accounts.currency_code%TYPE,
1287: p_bank_branch_name OUT NOCOPY ce_bank_branches_v.bank_branch_name%TYPE,
1288: p_bank_branch_id OUT NOCOPY ce_bank_accounts.bank_branch_id%TYPE,

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

1281: p_pay_method_id OUT NOCOPY ar_receipt_methods.receipt_method_id%TYPE,
1282: p_pay_method_name OUT NOCOPY ar_receipt_methods.name%TYPE,
1283: p_bank_name OUT NOCOPY ce_bank_branches_v.bank_name%TYPE,
1284: p_bank_account_num OUT NOCOPY ce_bank_accounts.bank_account_num%TYPE,
1285: p_bank_account_id OUT NOCOPY ce_bank_accounts.bank_account_id%TYPE,
1286: p_currency_code IN OUT NOCOPY ce_bank_accounts.currency_code%TYPE,
1287: p_bank_branch_name OUT NOCOPY ce_bank_branches_v.bank_branch_name%TYPE,
1288: p_bank_branch_id OUT NOCOPY ce_bank_accounts.bank_branch_id%TYPE,
1289: p_override_remit_flag OUT NOCOPY ar_receipt_method_accounts.override_remit_account_flag%TYPE,

Line 1286: p_currency_code IN OUT NOCOPY ce_bank_accounts.currency_code%TYPE,

1282: p_pay_method_name OUT NOCOPY ar_receipt_methods.name%TYPE,
1283: p_bank_name OUT NOCOPY ce_bank_branches_v.bank_name%TYPE,
1284: p_bank_account_num OUT NOCOPY ce_bank_accounts.bank_account_num%TYPE,
1285: p_bank_account_id OUT NOCOPY ce_bank_accounts.bank_account_id%TYPE,
1286: p_currency_code IN OUT NOCOPY ce_bank_accounts.currency_code%TYPE,
1287: p_bank_branch_name OUT NOCOPY ce_bank_branches_v.bank_branch_name%TYPE,
1288: p_bank_branch_id OUT NOCOPY ce_bank_accounts.bank_branch_id%TYPE,
1289: p_override_remit_flag OUT NOCOPY ar_receipt_method_accounts.override_remit_account_flag%TYPE,
1290: p_remit_flag OUT NOCOPY ar_receipt_classes.remit_flag%TYPE,

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

1284: p_bank_account_num OUT NOCOPY ce_bank_accounts.bank_account_num%TYPE,
1285: p_bank_account_id OUT NOCOPY ce_bank_accounts.bank_account_id%TYPE,
1286: p_currency_code IN OUT NOCOPY ce_bank_accounts.currency_code%TYPE,
1287: p_bank_branch_name OUT NOCOPY ce_bank_branches_v.bank_branch_name%TYPE,
1288: p_bank_branch_id OUT NOCOPY ce_bank_accounts.bank_branch_id%TYPE,
1289: p_override_remit_flag OUT NOCOPY ar_receipt_method_accounts.override_remit_account_flag%TYPE,
1290: p_remit_flag OUT NOCOPY ar_receipt_classes.remit_flag%TYPE,
1291: p_creation_status OUT NOCOPY ar_receipt_classes.creation_status%TYPE,
1292: p_meaning OUT NOCOPY ar_lookups.meaning%TYPE) IS

Line 1301: l_bank_account_num ce_bank_accounts.bank_account_num%TYPE;

1297: l_rec_class_name ar_receipt_classes.name%TYPE;
1298: l_pay_method_id ar_receipt_methods.receipt_method_id%TYPE;
1299: l_pay_method_name ar_receipt_methods.name%TYPE;
1300: l_bank_name ce_bank_branches_v.bank_name%TYPE;
1301: l_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
1302: l_bank_account_id ce_bank_accounts.bank_account_id%TYPE;
1303: l_currency_code ce_bank_accounts.currency_code%TYPE;
1304: l_bank_branch_name ce_bank_branches_v.bank_branch_name%TYPE;
1305: l_bank_branch_id ce_bank_accounts.bank_branch_id%TYPE;

Line 1302: l_bank_account_id ce_bank_accounts.bank_account_id%TYPE;

1298: l_pay_method_id ar_receipt_methods.receipt_method_id%TYPE;
1299: l_pay_method_name ar_receipt_methods.name%TYPE;
1300: l_bank_name ce_bank_branches_v.bank_name%TYPE;
1301: l_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
1302: l_bank_account_id ce_bank_accounts.bank_account_id%TYPE;
1303: l_currency_code ce_bank_accounts.currency_code%TYPE;
1304: l_bank_branch_name ce_bank_branches_v.bank_branch_name%TYPE;
1305: l_bank_branch_id ce_bank_accounts.bank_branch_id%TYPE;
1306: l_override_remit_flag ar_receipt_method_accounts.override_remit_account_flag%TYPE;

Line 1303: l_currency_code ce_bank_accounts.currency_code%TYPE;

1299: l_pay_method_name ar_receipt_methods.name%TYPE;
1300: l_bank_name ce_bank_branches_v.bank_name%TYPE;
1301: l_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
1302: l_bank_account_id ce_bank_accounts.bank_account_id%TYPE;
1303: l_currency_code ce_bank_accounts.currency_code%TYPE;
1304: l_bank_branch_name ce_bank_branches_v.bank_branch_name%TYPE;
1305: l_bank_branch_id ce_bank_accounts.bank_branch_id%TYPE;
1306: l_override_remit_flag ar_receipt_method_accounts.override_remit_account_flag%TYPE;
1307: l_remit_flag ar_receipt_classes.remit_flag%TYPE;

Line 1305: l_bank_branch_id ce_bank_accounts.bank_branch_id%TYPE;

1301: l_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
1302: l_bank_account_id ce_bank_accounts.bank_account_id%TYPE;
1303: l_currency_code ce_bank_accounts.currency_code%TYPE;
1304: l_bank_branch_name ce_bank_branches_v.bank_branch_name%TYPE;
1305: l_bank_branch_id ce_bank_accounts.bank_branch_id%TYPE;
1306: l_override_remit_flag ar_receipt_method_accounts.override_remit_account_flag%TYPE;
1307: l_remit_flag ar_receipt_classes.remit_flag%TYPE;
1308: l_creation_status ar_receipt_classes.creation_status%TYPE;
1309: l_meaning ar_lookups.meaning%TYPE;

Line 1435: FROM ce_bank_accounts cba,

1431: l_currency_code,
1432: l_bank_branch_name,
1433: l_bank_branch_id,
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

Line 1487: FROM ce_bank_accounts cba,

1483: AND l.lookup_type(+) = 'RECEIPT_CREATION_STATUS'
1484: AND EXISTS
1485: (SELECT
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

Line 1541: ce_bank_accounts cba,

1537: AND EXISTS
1538: (SELECT
1539: rm.receipt_class_id
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