APPS.OE_CREDIT_CHECK_ORDER_PVT dependencies on OE_ORDER_HOLDS

Line 134: FROM OE_ORDER_HOLDS h,

130:
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