APPS.MSC_CL_PURGE_STAGING dependencies on DUAL

Line 330: FROM dual;

326: CLOSE table_names;
327: SELECT DECODE(nvl(FND_PROFILE.VALUE('MRP_DEBUG'),'N'),'Y',1,2),
328: DECODE(nvl(FND_PROFILE.VALUE('MSC_PURGE_ST_CONTROL'),'No'),'Yes',1,2)
329: INTO v_debug,lv_trunc_profile
330: FROM dual;
331:
332:
333: IF (lv_trunc_profile = SYS_YES AND lv_p_del_rej_rec=SYS_NO ) THEN
334: SELECT count(*) INTO lv_leg_inst_flag FROM msc_apps_instances WHERE instance_type = G_INS_OTHER ;

Line 1956: FROM dual;

1952: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1,'inside purge staging table ');
1953:
1954: SELECT decode(nvl(fnd_profile.value('MSC_PURGE_ST_CONTROL'),'N'),'Y',1,2)
1955: INTO lv_control_flag
1956: FROM dual;
1957:
1958: IF p_instance_id IS NOT NULL THEN
1959: SELECT instance_type, lrtype
1960: INTO lv_instance_type, lv_last_refresh_type