APPS.OE_HOLDS_PVT dependencies on OE_SHIP_METHODS_V

Line 197: from oe_ship_methods_v

193: AND lookup_type = 'SOURCE_TYPE';
194:
195: CURSOR shipping_method_value_cur IS
196: select meaning
197: from oe_ship_methods_v
198: WHERE lookup_code= p_hold_entity_id
199: AND lookup_type = 'SHIP_METHOD';
200:
201: CURSOR currency_value_cur IS

Line 2503: FROM oe_ship_methods_v

2499: WHERE payment_type_code = p_hold_source_rec.hold_entity_id;
2500: ELSIF p_hold_source_rec.hold_entity_code = 'SM' THEN
2501: SELECT 'Valid Entity'
2502: INTO l_dummy
2503: FROM oe_ship_methods_v
2504: WHERE lookup_code= p_hold_source_rec.hold_entity_id
2505: AND lookup_type = 'SHIP_METHOD';
2506: --ER#7479609 end
2507: ELSE

Line 2648: from oe_ship_methods_v

2644: AND lookup_type = 'SALES_CHANNEL';
2645: ELSIF p_hold_source_rec.hold_entity_code2 = 'SM' THEN
2646: SELECT 'Valid Entity'
2647: INTO l_dummy
2648: from oe_ship_methods_v
2649: where lookup_code = p_hold_source_rec.hold_entity_id2
2650: AND lookup_type = 'SHIP_METHOD';
2651: ELSIF p_hold_source_rec.hold_entity_code2 = 'ST' THEN
2652: SELECT 'Valid Entity'