APPS.MSC_CL_ITEM_ODS_LOAD dependencies on DUAL

Line 1532: FROM dual;

1528: MSC_CL_COLLECTION.INITIALIZE( pINSTANCE_ID);
1529:
1530: SELECT decode(nvl(fnd_profile.value('MSC_PURGE_ST_CONTROL'),'N'),'Y',1,2)
1531: INTO lv_control_flag
1532: FROM dual;
1533:
1534: begin
1535: select num_rows,decode (stale_stats,'NO', MSC_UTIL.SYS_NO, MSC_UTIL.SYS_YES )
1536: into lv_item_id_count, lv_items_stat_stale