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
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
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