APPS.MSC_LAUNCH_PLAN_PK dependencies on MSC_24X7_PLAN_NAME_S

Line 1319: select '#'||nvl(substr(to_char(msc_24x7_plan_name_s.nextval),-9),msc_24x7_plan_name_s.nextval)

1315: -- Modified (forward port) for the bug # 3021850
1316: if v_org_desig_cur.purge_current_plan = 2 THEN
1317:
1318: loop
1319: select '#'||nvl(substr(to_char(msc_24x7_plan_name_s.nextval),-9),msc_24x7_plan_name_s.nextval)
1320: into lv_plan_name
1321: from dual;
1322:
1323: open c_plan_name(lv_plan_name);