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 3981: FROM dual;

3977:
3978:
3979: SELECT decode(nvl(fnd_profile.value('MSC_PURGE_ST_CONTROL'),'N'),'Y',1,2)
3980: INTO lv_control_flag
3981: FROM dual;
3982:
3983: BEGIN
3984: lv_msc_tp_coll_window := NVL(TO_NUMBER(FND_PROFILE.VALUE('MSC_COLLECTION_WINDOW_FOR_TP_CHANGES')),0);
3985: EXCEPTION