APPS.MSC_CL_SETUP_ODS_LOAD dependencies on DUAL

Line 151: FROM dual;

147: BEGIN
148:
149: SELECT decode(nvl(fnd_profile.value('MSC_PURGE_ST_CONTROL'),'N'),'Y',1,2)
150: INTO lv_control_flag
151: FROM dual;
152:
153: /* for bug: 2605884, added this piece of code to set the so_tbl_status to NO */
154:
155: IF (MSC_CL_COLLECTION.v_inv_ctp_val = 4) THEN -- PDS ATP , set SO_TBL_STATUS=2 , no matter type of collections

Line 3991: FROM dual;

3987:
3988:
3989: SELECT decode(nvl(fnd_profile.value('MSC_PURGE_ST_CONTROL'),'N'),'Y',1,2)
3990: INTO lv_control_flag
3991: FROM dual;
3992:
3993: BEGIN
3994: lv_msc_tp_coll_window := NVL(TO_NUMBER(FND_PROFILE.VALUE('MSC_COLLECTION_WINDOW_FOR_TP_CHANGES')),0);
3995: EXCEPTION