APPS.OE_HOLDS_PVT dependencies on OE_BLANKET_HEADERS

Line 2458: FROM oe_blanket_headers

2454: where ORGANIZATION_id = p_hold_source_rec.hold_entity_id;
2455: ELSIF p_hold_source_rec.hold_entity_code = 'H' THEN
2456: SELECT 'Valid Entity'
2457: INTO l_dummy
2458: FROM oe_blanket_headers
2459: WHERE ORDER_NUMBER = p_hold_source_rec.hold_entity_id
2460: AND SALES_DOCUMENT_TYPE_CODE = 'B';
2461: --ER#7479609 start
2462: ELSIF p_hold_source_rec.hold_entity_code = 'TM' THEN

Line 2583: FROM oe_blanket_headers

2579: AND site_use_code = 'BILL_TO';
2580: ELSIF p_hold_source_rec.hold_entity_code2 = 'H' THEN
2581: SELECT 'Valid Entity'
2582: INTO l_dummy
2583: FROM oe_blanket_headers
2584: WHERE ORDER_NUMBER = p_hold_source_rec.hold_entity_id2
2585: AND SALES_DOCUMENT_TYPE_CODE = 'B';
2586: ELSIF p_hold_source_rec.hold_entity_code2 = 'L' THEN
2587: SELECT 'Valid Entity'