APPS.OE_VERIFY_PAYMENT_PUB dependencies on OE_ORDER_HOLDS

Line 238: FROM OE_ORDER_HOLDS h,

234: --
235: --added for BUG#9728597 Start
236: cursor released_hold is
237: SELECT ohr.HOLD_RELEASE_ID
238: FROM OE_ORDER_HOLDS h,
239: OE_HOLD_SOURCES s,
240: oe_hold_releases ohr
241: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
242: AND H.HEADER_ID = p_header_id

Line 254: FROM OE_ORDER_HOLDS h,

250: ORDER BY ohr.creation_date DESC;
251:
252: cursor released_hold_line is
253: SELECT ohr.HOLD_RELEASE_ID
254: FROM OE_ORDER_HOLDS h,
255: OE_HOLD_SOURCES s,
256: oe_hold_releases ohr
257: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
258: AND H.HEADER_ID = p_header_id

Line 279: FROM OE_ORDER_HOLDS h,

275: BEGIN
276: --commented for BUG#9728597 Start
277: /*SELECT NVL(MAX(H.HOLD_RELEASE_ID),0)
278: INTO l_hold_release_id
279: FROM OE_ORDER_HOLDS h,
280: OE_HOLD_SOURCES s
281: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
282: AND H.HEADER_ID = p_header_id
283: AND H.LINE_ID IS NULL

Line 320: FROM OE_ORDER_HOLDS h,

316: BEGIN
317: --commented for BUG#9728597 Start
318: /*SELECT NVL(MAX(H.HOLD_RELEASE_ID),0)
319: INTO l_hold_release_id
320: FROM OE_ORDER_HOLDS h,
321: OE_HOLD_SOURCES s
322: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
323: AND H.HEADER_ID = p_header_id
324: AND H.LINE_ID = p_line_id