APPS.OE_CREDIT_CHECK_LINES_PVT dependencies on OE_ORDER_HOLDS_ALL

Line 3174: FROM OE_ORDER_HOLDS_all h,

3170: -- To retrieve the credit profile level of the latest manually released hold.
3171: CURSOR released_hold
3172: IS
3173: SELECT Credit_Profile_Level
3174: FROM OE_ORDER_HOLDS_all h,
3175: OE_HOLD_SOURCES_ALL s,
3176: oe_hold_releases ohr
3177: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
3178: AND H.HEADER_ID = p_header_rec.header_id

Line 3193: FROM OE_ORDER_HOLDS_all h,

3189: --13706069 start
3190: CURSOR released_hold_line(p_line_id IN NUMBER)
3191: IS
3192: SELECT Credit_Profile_Level
3193: FROM OE_ORDER_HOLDS_all h,
3194: OE_HOLD_SOURCES_ALL s,
3195: oe_hold_releases ohr
3196: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
3197: AND H.HEADER_ID = p_header_rec.header_id

Line 4281: FROM oe_order_holds_all oh,

4277: OR l.payment_type_code IS NULL
4278: )
4279: AND (EXISTS
4280: (SELECT 'Y'
4281: FROM oe_order_holds_all oh,
4282: oe_hold_sources_all hs
4283: WHERE oh.header_id = p_header_rec.header_id
4284: AND oh.line_id = l.line_id
4285: AND oh.hold_release_id IS NULL

Line 4294: FROM OE_ORDER_HOLDS_ALL OOH,

4290: --ER 12363706 start
4291:
4292: CURSOR latest_hold_rec(p_header_id IN NUMBER) IS
4293: SELECT OHS.HOLD_SOURCE_ID
4294: FROM OE_ORDER_HOLDS_ALL OOH,
4295: OE_HOLD_SOURCES_ALL OHS
4296: WHERE OOH.HOLD_SOURCE_ID = OHS.HOLD_SOURCE_ID
4297: AND OOH.HEADER_ID = p_header_id
4298: AND OHS.HOLD_ID = 1