DBA Data[Home] [Help]

APPS.OE_CREDIT_CHECK_ORDER_PVT dependencies on OE_ORDER_HOLDS_ALL

Line 2392: FROM OE_ORDER_HOLDS_all h,

2388: -- To retrieve the credit profile level of the latest manually released hold.
2389: CURSOR released_hold
2390: IS
2391: SELECT Credit_Profile_Level
2392: FROM OE_ORDER_HOLDS_all h,
2393: OE_HOLD_SOURCES_ALL s,
2394: oe_hold_releases ohr
2395: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
2396: AND H.HEADER_ID = p_header_rec.header_id