APPS.ARP_RW_BATCHES_PKG dependencies on AR_LOOKUPS

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

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,
1292: p_meaning OUT NOCOPY ar_lookups.meaning%TYPE) IS
1293:
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;

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

Line 1477: ar_lookups l

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

Line 1533: ar_lookups l

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