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 862: FROM ce_bank_branches_v

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

Line 884: FROM ce_bank_branches_v bb

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

Line 899: ce_bank_branches_v bb2,

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

Line 929: ce_bank_branches_v br,

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

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

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

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

Line 1300: l_bank_name ce_bank_branches_v.bank_name%TYPE;

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

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

Line 1436: ce_bank_branches_v bb,

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

Line 1488: ce_bank_branches_v bb,

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

Line 1542: ce_bank_branches_v bb,

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