APPS.MSC_PURGE_LID dependencies on DUAL

Line 1877: SELECT REPLACE(lv_inst_str,'''','') INTO lv_inst_str FROM DUAL;

1873:
1874:
1875: -- make inst str number only
1876:
1877: SELECT REPLACE(lv_inst_str,'''','') INTO lv_inst_str FROM DUAL;
1878:
1879: --
1880:
1881: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1,'******* Delete Rows for Instance *******');

Line 2277: SELECT REPLACE(lv_plan_str,'''','') INTO lv_plan_str FROM DUAL;

2273: END;
2274:
2275: -- change plan list to number only
2276:
2277: SELECT REPLACE(lv_plan_str,'''','') INTO lv_plan_str FROM DUAL;
2278:
2279: --
2280:
2281: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1,'******* Delete Rows for plan***********');