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 443: FROM ar_receipt_methods rm

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

Line 875: FROM ar_receipt_methods rm

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

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

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

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

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

Line 1297: l_pay_method_id ar_receipt_methods.receipt_method_id%TYPE;

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

Line 1298: l_pay_method_name ar_receipt_methods.name%TYPE;

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

Line 1475: ar_receipt_methods rm,

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

Line 1539: FROM ar_receipt_methods rm,

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