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 AR_RECEIPT_METHODS

Line 444: FROM ar_receipt_methods rm

440:
441:
442: CURSOR c_valid_receipt_method IS
443: SELECT rm.receipt_method_id
444: FROM ar_receipt_methods rm
445: WHERE rm.receipt_method_id = l_batch_rec.receipt_method_id
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

Line 876: FROM ar_receipt_methods rm

872: OR rc.remit_method_code = 'STANDARD_AND_FACTORING');
873:
874: CURSOR c_valid_receipt_method IS
875: SELECT rm.receipt_method_id
876: FROM ar_receipt_methods rm
877: WHERE rm.receipt_method_id = l_batch_rec.receipt_method_id
878: AND rm.receipt_class_id = l_batch_rec.receipt_class_id
879: AND l_batch_rec.batch_date between rm.start_date and nvl(rm.end_date, l_batch_rec.batch_date);
880:

Line 1281: p_pay_method_id OUT NOCOPY ar_receipt_methods.receipt_method_id%TYPE,

1277: p_batch_source_id IN OUT NOCOPY ar_batch_sources.batch_source_id%TYPE,
1278: p_batch_number OUT NOCOPY ar_batch_sources.auto_batch_numbering%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,

Line 1282: p_pay_method_name OUT NOCOPY ar_receipt_methods.name%TYPE,

1278: p_batch_number OUT NOCOPY ar_batch_sources.auto_batch_numbering%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,

Line 1298: l_pay_method_id ar_receipt_methods.receipt_method_id%TYPE;

1294: l_batch_source_id ar_batch_sources.batch_source_id%TYPE;
1295: l_batch_number ar_batch_sources.auto_batch_numbering%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;

Line 1299: l_pay_method_name ar_receipt_methods.name%TYPE;

1295: l_batch_number ar_batch_sources.auto_batch_numbering%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;

Line 1476: ar_receipt_methods rm,

1472: l_creation_status,
1473: l_meaning,
1474: l_remit_flag
1475: FROM ar_receipt_classes rc,
1476: ar_receipt_methods rm,
1477: ar_lookups l
1478: WHERE rc.receipt_class_id=l_rec_class_id
1479: AND rc.receipt_class_id = rm.receipt_class_id
1480: AND rm.receipt_method_id = l_pay_method_id

Line 1540: FROM ar_receipt_methods rm,

1536: AND l.lookup_type(+) = 'RECEIPT_CREATION_STATUS'
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