APPS.AR_RECEIPT_VAL_PVT dependencies on AR_LOOKUPS

Line 947: SELECT arl.lookup_code FROM ar_lookups arl

943: AND cr.amount = p_amount
944: AND NVL(cr.pay_from_customer, -99999) = NVL(p_customer_id, -99999)
945: AND cr.type = p_type
946: AND cr.status NOT IN (
947: SELECT arl.lookup_code FROM ar_lookups arl
948: WHERE arl.lookup_type = 'REVERSAL_CATEGORY_TYPE');
949:
950: BEGIN
951: IF PG_DEBUG in ('Y', 'C') THEN

Line 2515: FROM ar_lookups

2511: END IF;
2512: IF p_reversal_category_code IS NOT NULL THEN
2513: SELECT count(*)
2514: INTO l_valid
2515: FROM ar_lookups
2516: WHERE lookup_type = 'REVERSAL_CATEGORY_TYPE'
2517: and enabled_flag = 'Y'
2518: and lookup_code = p_reversal_category_code;
2519: IF l_valid =0 THEN

Line 2550: FROM ar_lookups

2546: p_return_status := FND_API.G_RET_STS_SUCCESS;
2547: IF p_reversal_reason_code IS NOT NULL THEN
2548: SELECT count(*)
2549: INTO l_valid
2550: FROM ar_lookups
2551: WHERE lookup_type = 'CKAJST_REASON'
2552: and enabled_flag = 'Y'
2553: and lookup_code = p_reversal_reason_code;
2554: IF l_valid =0 THEN

Line 3257: FROM ar_lookups

3253: IF p_applied_ps_id IS NOT NULL and p_applied_ps_id in (-4,-5,-6,-7) THEN
3254: BEGIN
3255: SELECT 'Y'
3256: INTO l_valid
3257: FROM ar_lookups
3258: WHERE lookup_type = DECODE(p_applied_ps_id,-4,'APPLICATION_REF_TYPE',
3259: -5,'CHARGEBACK',
3260: -6, 'MISC_RECEIPT',
3261: -7,'AR_PREPAYMENT_TYPE',