APPS.MSC_LAUNCH_PLAN_PK dependencies on MSC_24X7_PLAN_NAME_S

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

1232: -- Modified (forward port) for the bug # 3021850
1233: if v_org_desig_cur.purge_current_plan = 2 THEN
1234:
1235: loop
1236: select '#'||nvl(substr(to_char(msc_24x7_plan_name_s.nextval),-9),msc_24x7_plan_name_s.nextval)
1237: into lv_plan_name
1238: from dual;
1239:
1240: open c_plan_name(lv_plan_name);