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_BRANCHES_V

Line 861: FROM ce_bank_branches_v

857: l_batch_rec ar_batches%ROWTYPE;
858: l_institution_type VARCHAR2(30);
859: CURSOR c_bank_branches IS
860: SELECT bank_institution_type
861: FROM ce_bank_branches_v
862: WHERE branch_party_id = p_remittance_bank_branch_id;
863:
864: CURSOR c_valid_receipt_class IS
865: SELECT rc.receipt_class_id

Line 883: FROM ce_bank_branches_v bb

879:
880:
881: CURSOR c_valid_bank_branch IS
882: SELECT distinct bb.branch_party_id
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,

Line 898: ce_bank_branches_v bb2,

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,
902: hz_contact_points Eft

Line 928: ce_bank_branches_v br,

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)
932: AND rma.remit_bank_acct_use_id = ba.bank_acct_use_id

Line 1282: p_bank_name OUT NOCOPY ce_bank_branches_v.bank_name%TYPE,

1278: p_rec_class_id OUT NOCOPY ar_receipt_classes.receipt_class_id%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,

Line 1286: p_bank_branch_name OUT NOCOPY ce_bank_branches_v.bank_branch_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,
1290: p_creation_status OUT NOCOPY ar_receipt_classes.creation_status%TYPE,

Line 1299: l_bank_name ce_bank_branches_v.bank_name%TYPE;

1295: l_rec_class_id ar_receipt_classes.receipt_class_id%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;

Line 1303: l_bank_branch_name ce_bank_branches_v.bank_branch_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;
1307: l_creation_status ar_receipt_classes.creation_status%TYPE;

Line 1435: ce_bank_branches_v bb,

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
1439: AND rma.receipt_method_id = l_pay_method_id

Line 1487: ce_bank_branches_v bb,

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
1491: AND rma.remit_bank_acct_use_id = ba.bank_acct_use_id

Line 1541: ce_bank_branches_v bb,

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
1545: AND rm.receipt_method_id = rma.receipt_method_id