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 449: ce_bank_accounts cba,

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

Line 887: FROM ce_bank_accounts cba,

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

Line 896: ce_bank_accounts cba2,

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

Line 926: FROM ce_bank_accounts cba,

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

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

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

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

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

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

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

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

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

Line 1300: l_bank_account_num ce_bank_accounts.bank_account_num%TYPE;

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

Line 1301: l_bank_account_id ce_bank_accounts.bank_account_id%TYPE;

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

Line 1302: l_currency_code ce_bank_accounts.currency_code%TYPE;

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

Line 1304: l_bank_branch_id ce_bank_accounts.bank_branch_id%TYPE;

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

Line 1434: FROM ce_bank_accounts cba,

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

Line 1486: FROM ce_bank_accounts cba,

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

Line 1540: ce_bank_accounts cba,

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