APPS.MSC_CL_OTHER_ODS_LOAD dependencies on DUAL

Line 1479: FROM dual;

1475:
1476: SELECT
1477: decode(nvl(fnd_profile.value('MSC_PURGE_ST_CONTROL'),'N'),'Y',1,2)
1478: INTO lv_control_flag
1479: FROM dual;
1480:
1481: /*
1482: Bug 5126455
1483: Tables:

Line 3180: FROM dual

3176:
3177:
3178: SELECT 1
3179: INTO lv_rec_count
3180: FROM dual
3181: WHERE EXISTS(SELECT 1
3182: FROM msc_st_bis_periods
3183: WHERE sr_instance_id = MSC_CL_COLLECTION.v_instance_id);
3184: EXCEPTION