APPS.OE_CREDIT_CHECK_ORDER_PVT dependencies on OE_HOLD_SOURCES_ALL

Line 116: OE_HOLD_SOURCES_ALL s,

112: --added for BUG#9728597 Start
113: cursor released_hold is
114: SELECT ohr.HOLD_RELEASE_ID
115: FROM OE_ORDER_HOLDS h,
116: OE_HOLD_SOURCES_ALL s,
117: oe_hold_releases ohr
118: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
119: AND H.HEADER_ID = p_header_id
120: AND H.LINE_ID IS NULL

Line 159: OE_HOLD_SOURCES_ALL s

155: /*
156: SELECT /* MOAC_SQL_CHANGE */ /*NVL(MAX(H.HOLD_RELEASE_ID),0)
157: INTO l_hold_release_id
158: FROM OE_ORDER_HOLDS h,
159: OE_HOLD_SOURCES_ALL s
160: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
161: AND H.HEADER_ID = p_header_id
162: AND H.LINE_ID IS NULL
163: AND H.HOLD_RELEASE_ID IS NOT NULL

Line 1002: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE := p_header_id; --ER#7479609

998: )
999: IS
1000:
1001: --ER#7479609 l_hold_entity_id NUMBER := p_header_id;
1002: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE := p_header_id; --ER#7479609
1003: l_hold_id NUMBER;
1004: l_hold_exists VARCHAR2(1);
1005: l_hold_result VARCHAR2(30);
1006: l_msg_count NUMBER := 0;

Line 2393: OE_HOLD_SOURCES_ALL s,

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
2397: AND H.LINE_ID IS NULL