APPS.AR_CMGT_CREDIT_REQUEST_API dependencies on AR_LOOKUPS

Line 272: FROM ar_lookups

268: */
269: BEGIN
270: SELECT 'X'
271: INTO l_char
272: FROM ar_lookups
273: WHERE lookup_type = 'OCM_CREDIT_REQUEST_TYPE'
274: AND lookup_code = l_credit_request_type;
275: EXCEPTION
276: WHEN OTHERS THEN

Line 640: FROM ar_lookups

636: ELSE
637: --verify the specified value is from lookups
638: BEGIN
639: SELECT lookup_code INTO l_credit_type
640: FROM ar_lookups
641: WHERE lookup_type = 'AR_CMGT_CREDIT_TYPE'
642: AND lookup_code = p_credit_type;
643:
644: EXCEPTION