APPS.OE_CREDIT_CHECK_UTIL dependencies on OE_HOLD_SOURCES

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'

Line 11492: ,p_cc_hold_comment IN OE_HOLD_SOURCES.hold_comment%TYPE

11488: ------------------------------------------------------------
11489: PROCEDURE SEND_CREDIT_HOLD_NTF
11490: (p_header_rec IN OE_ORDER_PUB.header_rec_type
11491: ,p_credit_hold_level IN OE_CREDIT_CHECK_RULES.credit_hold_level_code%TYPE
11492: ,p_cc_hold_comment IN OE_HOLD_SOURCES.hold_comment%TYPE
11493: ,x_return_status OUT NOCOPY VARCHAR2
11494: )
11495: IS
11496: