DBA Data[Home] [Help]

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