APPS.OE_CREDIT_CHECK_UTIL dependencies on OE_HOLD_SOURCES_ALL

Line 4424: FROM OE_HOLD_SOURCES_ALL HS

4420: BEGIN
4421: IF p_hold_source_rec.line_id IS NOT NULL THEN
4422: SELECT hold_source_id
4423: INTO l_hold_source_id
4424: FROM OE_HOLD_SOURCES_ALL HS
4425: WHERE HOLD_ENTITY_CODE = p_hold_source_rec.HOLD_ENTITY_CODE
4426: AND HOLD_ENTITY_ID = p_hold_source_rec.HOLD_ENTITY_ID
4427: AND HOLD_ID = p_hold_source_rec.hold_id
4428: AND RELEASED_FLAG = 'N'

Line 4437: FROM OE_HOLD_SOURCES_ALL

4433: AND OH.HOLD_SOURCE_ID = HS.HOLD_SOURCE_ID);
4434: ELSE
4435: SELECT hold_source_id
4436: INTO l_hold_source_id
4437: FROM OE_HOLD_SOURCES_ALL
4438: WHERE HOLD_ENTITY_CODE = p_hold_source_rec.HOLD_ENTITY_CODE
4439: AND HOLD_ENTITY_ID = p_hold_source_rec.HOLD_ENTITY_ID
4440: AND HOLD_ID = p_hold_source_rec.hold_id
4441: AND RELEASED_FLAG = 'N'