APPS.OE_HOLDS_PVT dependencies on OE_SHIP_METHODS_V

Line 143: from oe_ship_methods_v

139: AND lookup_type = 'SOURCE_TYPE';
140:
141: CURSOR shipping_method_value_cur IS
142: select meaning
143: from oe_ship_methods_v
144: WHERE lookup_code= p_hold_entity_id
145: AND lookup_type = 'SHIP_METHOD';
146:
147: CURSOR currency_value_cur IS

Line 2058: FROM oe_ship_methods_v

2054: WHERE payment_type_code = p_hold_source_rec.hold_entity_id;
2055: ELSIF p_hold_source_rec.hold_entity_code = 'SM' THEN
2056: SELECT 'Valid Entity'
2057: INTO l_dummy
2058: FROM oe_ship_methods_v
2059: WHERE lookup_code= p_hold_source_rec.hold_entity_id
2060: AND lookup_type = 'SHIP_METHOD';
2061: --ER#7479609 end
2062: ELSE

Line 2193: from oe_ship_methods_v

2189: AND lookup_type = 'SALES_CHANNEL';
2190: ELSIF p_hold_source_rec.hold_entity_code2 = 'SM' THEN
2191: SELECT 'Valid Entity'
2192: INTO l_dummy
2193: from oe_ship_methods_v
2194: where lookup_code = p_hold_source_rec.hold_entity_id2
2195: AND lookup_type = 'SHIP_METHOD';
2196: ELSIF p_hold_source_rec.hold_entity_code2 = 'ST' THEN
2197: SELECT 'Valid Entity'