APPS.OE_CREDIT_WF dependencies on OE_HOLD_RELEASES

Line 858: ,oe_hold_releases ohr

854: CURSOR released_hold IS
855: --added for BUG#9728597 Start
856: SELECT ohr.HOLD_RELEASE_ID
857: FROM OE_ORDER_HOLDS H, OE_HOLD_SOURCES S
858: ,oe_hold_releases ohr
859: WHERE H.HEADER_ID = header_id
860: AND H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
861: AND H.HOLD_RELEASE_ID IS NOT NULL
862: AND S.HOLD_ID = 1

Line 904: FROM OE_HOLD_RELEASES

900: IF l_hold_release_id > 0 THEN
901:
902: SELECT count(*)
903: INTO l_manual_release
904: FROM OE_HOLD_RELEASES
905: WHERE HOLD_RELEASE_ID = l_hold_release_id
906: AND RELEASE_REASON_CODE <> 'PASS_CREDIT'
907: AND CREATED_BY <> 1;
908: