DBA Data[Home] [Help]

APPS.CN_SRP_PLAN_ASSIGNS_PVT dependencies on DUAL

Line 184: SELECT 1 INTO l_dummy FROM dual

180:
181: -- check if duplicate
182: BEGIN
183: IF x_srp_plan_assigns_row.srp_plan_assign_id IS NULL THEN
184: SELECT 1 INTO l_dummy FROM dual
185: WHERE NOT EXISTS
186: (SELECT 1
187: FROM cn_srp_plan_assigns
188: WHERE role_plan_id = p_role_plan_id