APPS.OE_HOLDS_PVT dependencies on OE_BLANKET_HEADERS

Line 2013: FROM oe_blanket_headers

2009: where ORGANIZATION_id = p_hold_source_rec.hold_entity_id;
2010: ELSIF p_hold_source_rec.hold_entity_code = 'H' THEN
2011: SELECT 'Valid Entity'
2012: INTO l_dummy
2013: FROM oe_blanket_headers
2014: WHERE ORDER_NUMBER = p_hold_source_rec.hold_entity_id
2015: AND SALES_DOCUMENT_TYPE_CODE = 'B';
2016: --ER#7479609 start
2017: ELSIF p_hold_source_rec.hold_entity_code = 'TM' THEN

Line 2128: FROM oe_blanket_headers

2124: AND site_use_code = 'BILL_TO';
2125: ELSIF p_hold_source_rec.hold_entity_code2 = 'H' THEN
2126: SELECT 'Valid Entity'
2127: INTO l_dummy
2128: FROM oe_blanket_headers
2129: WHERE ORDER_NUMBER = p_hold_source_rec.hold_entity_id2
2130: AND SALES_DOCUMENT_TYPE_CODE = 'B';
2131: ELSIF p_hold_source_rec.hold_entity_code2 = 'L' THEN
2132: SELECT 'Valid Entity'