APPS.HZ_CREDIT_REQUEST_PVT dependencies on AR_CMGT_CF_RECOMMENDS

Line 114: FROM ar_cmgt_cf_recommends

110: --check that the recomendation exist
111:
112: SELECT COUNT(1)
113: INTO l_count
114: FROM ar_cmgt_cf_recommends
115: WHERE credit_request_id = l_credit_request_id
116: AND credit_recommendation = 'REMOVE_ORDER_HOLD'
117: AND status = 'I';
118: