APPS.ARP_RW_BATCHES_PKG dependencies on AR_LOOKUPS

Line 1291: p_meaning OUT NOCOPY ar_lookups.meaning%TYPE) IS

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
1292:
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;

Line 1308: l_meaning ar_lookups.meaning%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;
1309: l_num NUMBER;
1310: --Bug fix 5647335 starts
1311: l_default_org_id NUMBER;
1312: l_defaulted_flag VARCHAR2(3);

Line 1476: ar_lookups l

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
1480: AND p_batch_date between rm.start_date and NVL(rm.end_date,p_batch_date)

Line 1532: ar_lookups l

1528: l_creation_status,
1529: l_meaning,
1530: l_remit_flag
1531: FROM ar_receipt_classes rc,
1532: ar_lookups l
1533: WHERE rc.receipt_class_id=l_rec_class_id
1534: AND rc.creation_status = l.lookup_code(+)
1535: AND l.lookup_type(+) = 'RECEIPT_CREATION_STATUS'
1536: AND EXISTS