APPS.AR_CMGT_CREDIT_REQUEST_API dependencies on AR_LOOKUPS

Line 287: FROM ar_lookups

283: */
284: BEGIN
285: SELECT 'X'
286: INTO l_char
287: FROM ar_lookups
288: WHERE lookup_type = 'OCM_CREDIT_REQUEST_TYPE'
289: AND lookup_code = l_credit_request_type;
290: EXCEPTION
291: WHEN OTHERS THEN

Line 646: FROM ar_lookups

642: ELSE
643: --verify the specified value is from lookups
644: BEGIN
645: SELECT lookup_code INTO l_credit_type
646: FROM ar_lookups
647: WHERE lookup_type = 'AR_CMGT_CREDIT_TYPE'
648: AND lookup_code = p_credit_type;
649:
650: EXCEPTION