APPS.IEU_WORK_SOURCE_PVT dependencies on DUAL

Line 75: select to_char(sysdate, 'yyyy/mm/dd') into l_temp_date from dual;

71: fnd_msg_pub.delete_msg();
72: x_return_status := fnd_api.g_ret_sts_success;
73: FND_MSG_PUB.initialize;
74: x_msg_data := '';
75: select to_char(sysdate, 'yyyy/mm/dd') into l_temp_date from dual;
76: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
77: -- for update description and dis function for not active case,
78: -- do not check ws object code
79: -- check ws object code only when deactive -> active

Line 176: select IEU_UWQM_WORK_SOURCES_B_S1.NEXTVAL into l_ws_id from sys.dual;

172: x_end_date_active => null,
173: x_sql_validation => p_sqlValidation);
174:
175: -- b. insert ieu_uwqm_work_sources_b and tl
176: select IEU_UWQM_WORK_SOURCES_B_S1.NEXTVAL into l_ws_id from sys.dual;
177: IEU_UWQM_WORK_SOURCES_PKG.load_row(
178: l_ws_id,
179: p_ws_type,
180: p_ws_dis_to,

Line 196: select IEU_UWQM_WS_ASSCT_PROPS_S1.NEXTVAL into l_ws_assoc_prop_id from sys.dual;

192:
193:
194: -- c. if this is association type, insert ieu_uwqm_ws_assct_props
195: IF (p_ws_parent_id <> '0') then
196: select IEU_UWQM_WS_ASSCT_PROPS_S1.NEXTVAL into l_ws_assoc_prop_id from sys.dual;
197:
198: IEU_UWQM_WS_ASSCT_PROPS_PKG.insert_row(
199: x_rowid => x_rowid,
200: p_ws_association_prop_id =>l_ws_assoc_prop_id,