APPS.OE_CREDIT_CHECK_ORDER_PVT dependencies on OE_HOLD_SOURCES_ALL

Line 135: OE_HOLD_SOURCES_ALL s

131: BEGIN
132: SELECT /* MOAC_SQL_CHANGE */ NVL(MAX(H.HOLD_RELEASE_ID),0)
133: INTO l_hold_release_id
134: FROM OE_ORDER_HOLDS h,
135: OE_HOLD_SOURCES_ALL s
136: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
137: AND H.HEADER_ID = p_header_id
138: AND H.LINE_ID IS NULL
139: AND H.HOLD_RELEASE_ID IS NOT NULL

Line 900: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE := p_header_id; --ER#7479609

896: )
897: IS
898:
899: --ER#7479609 l_hold_entity_id NUMBER := p_header_id;
900: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE := p_header_id; --ER#7479609
901: l_hold_id NUMBER;
902: l_hold_exists VARCHAR2(1);
903: l_hold_result VARCHAR2(30);
904: l_msg_count NUMBER := 0;