APPS.MSC_CL_ITEM_ODS_LOAD dependencies on DUAL

Line 1536: FROM dual;

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