APPS.MSC_COPY_PLAN_OPTIONS dependencies on DUAL

Line 65: from dual;

61:
62: if NVL(L_Temp_plan,'N') = 'N' then
63: select msc_designators_s.nextval
64: into v_designator_id
65: from dual;
66: L_designator_id := v_designator_id;
67: else
68: v_designator_id := L_designator_id;
69: end if;

Line 85: from dual;

81: 103,103,
82: 104,104,
83: 105,105)
84: into v_designator_type
85: from dual;
86:
87: select nvl(organization_selection,3),designator_id
88: into l_org_selection , v_prev_designator_id
89: from msc_designators

Line 700: from dual;

696: ''''||to_char(p_bind_var_col(1).P_CREATION_DATE , 'DD-MON-RRRR')||''''
697: ,'CREATED_BY' ,
698: nvl(to_char(p_bind_var_col(1).P_CREATED_BY),'null')
699: , p_column_name /* 'null' */ ) into l_temp
700: from dual;
701:
702: elsif p_source_table = 'MSC_PLANS' then
703:
704: select decode(p_column_name ,'LAST_UPDATE_DATE' ,

Line 732: , p_column_name) into l_temp from dual;

728: ,'DATA_COMPLETION_DATE' , 'null'
729: ,'PLAN_RUN_DATE' , 'null'
730: ,'ORGANIZATION_SELECTION' ,
731: nvl(to_char(p_bind_var_col(1).P_REFRESH_NUMBER),'null')
732: , p_column_name) into l_temp from dual;
733:
734: elsif p_source_table in
735: ('MSC_PLAN_SCHEDULES', 'MSC_PLAN_ORGANIZATIONS', 'MSC_SUB_INVENTORIES',
736: 'MSC_PLANS_OTHER',

Line 752: , p_column_name) into l_temp from dual;

748: ,'LAST_UPDATE_LOGIN' ,
749: nvl(to_char(p_bind_var_col(1).P_LAST_UPDATE_LOGIN),'null')
750: ,'PLAN_ID' ,
751: nvl(to_char(p_bind_var_col(1).P_DEST_PLAN_ID),'null')
752: , p_column_name) into l_temp from dual;
753:
754: end if;
755:
756: return l_temp ;