APPS.MSC_CL_PURGE_STAGING dependencies on DUAL

Line 329: FROM dual;

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

Line 1955: FROM dual;

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