APPS.OE_VERIFY_PAYMENT_PUB dependencies on OE_ORDER_HOLDS

Line 244: FROM OE_ORDER_HOLDS h,

240: IF p_line_id IS NULL THEN
241: BEGIN
242: SELECT NVL(MAX(H.HOLD_RELEASE_ID),0)
243: INTO l_hold_release_id
244: FROM OE_ORDER_HOLDS h,
245: OE_HOLD_SOURCES s
246: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
247: AND H.HEADER_ID = p_header_id
248: AND H.LINE_ID IS NULL

Line 269: FROM OE_ORDER_HOLDS h,

265: -- p_line_id is not null, this is line level credit check.
266: BEGIN
267: SELECT NVL(MAX(H.HOLD_RELEASE_ID),0)
268: INTO l_hold_release_id
269: FROM OE_ORDER_HOLDS h,
270: OE_HOLD_SOURCES s
271: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
272: AND H.HEADER_ID = p_header_id
273: AND H.LINE_ID = p_line_id