APPS.AR_RECEIPT_VAL_PVT dependencies on AR_LOOKUPS

Line 2445: FROM ar_lookups

2441: END IF;
2442: IF p_reversal_category_code IS NOT NULL THEN
2443: SELECT count(*)
2444: INTO l_valid
2445: FROM ar_lookups
2446: WHERE lookup_type = 'REVERSAL_CATEGORY_TYPE'
2447: and enabled_flag = 'Y'
2448: and lookup_code = p_reversal_category_code;
2449: IF l_valid =0 THEN

Line 2480: FROM ar_lookups

2476: p_return_status := FND_API.G_RET_STS_SUCCESS;
2477: IF p_reversal_reason_code IS NOT NULL THEN
2478: SELECT count(*)
2479: INTO l_valid
2480: FROM ar_lookups
2481: WHERE lookup_type = 'CKAJST_REASON'
2482: and enabled_flag = 'Y'
2483: and lookup_code = p_reversal_reason_code;
2484: IF l_valid =0 THEN

Line 3120: FROM ar_lookups

3116: IF p_applied_ps_id IS NOT NULL and p_applied_ps_id in (-4,-5,-6,-7) THEN
3117: BEGIN
3118: SELECT 'Y'
3119: INTO l_valid
3120: FROM ar_lookups
3121: WHERE lookup_type = DECODE(p_applied_ps_id,-4,'APPLICATION_REF_TYPE',
3122: -5,'CHARGEBACK',
3123: -6, 'MISC_RECEIPT',
3124: -7,'AR_PREPAYMENT_TYPE',