APPS.MRP_RESCHEDULE_CMRO_WO_PS dependencies on FND_PROFILE

Line 329: IF (NVL(fnd_profile.value('MSC_RETAIN_RELEASED_DATA'), 'N') ='N' )THEN

325: IF (lv_wo_count > 0 or lv_wo_count1 > 0) THEN
326: log_output('================== ==================== ==================== =========== ');
327: END IF;
328: --- for CMRO
329: IF (NVL(fnd_profile.value('MSC_RETAIN_RELEASED_DATA'), 'N') ='N' )THEN
330:
331: lv_sql_stmt := 'DELETE msc_wip_job_schedule_interface'||g_dblink
332: ||' where sr_instance_id ='|| P_SR_INSTANCE_ID
333: ||' and nvl(group_id,-1) = nvl('||g_group_id||',-1)'