APPS.INV_LPN_RESERVATIONS_PVT dependencies on DUAL

Line 45: FROM dual

41: BEGIN
42: IF p_demand_source_type_id IN (2,8,12) THEN
43: SELECT 1
44: INTO l_result
45: FROM dual
46: WHERE EXISTS (
47: SELECT 1
48: FROM mtl_reservations
49: WHERE organization_id = p_org_id

Line 58: FROM dual

54: );
55: ELSIF p_demand_source_type_id IN (3,6) THEN
56: SELECT 1
57: INTO l_result
58: FROM dual
59: WHERE EXISTS (
60: SELECT 1
61: FROM mtl_reservations
62: WHERE organization_id = p_org_id

Line 71: FROM dual

67: );
68: ELSE
69: SELECT 1
70: INTO l_result
71: FROM dual
72: WHERE EXISTS (
73: SELECT 1
74: FROM mtl_reservations
75: WHERE organization_id = p_org_id

Line 262: l_fb := nvl(OE_DUAL_UOM_UTIL.get_fulfillment_base(p_demand_source_line_id), 'P'); -- 16773889

258: WHEN NO_DATA_FOUND THEN
259: l_ord_qty := 0;
260: END;
261:
262: l_fb := nvl(OE_DUAL_UOM_UTIL.get_fulfillment_base(p_demand_source_line_id), 'P'); -- 16773889
263: END IF; -- 16773889
264: --convert ordered qty into primary UOM.
265: IF l_ord_qty <> 0 THEN
266: