APPS.CSE_FA_STAGE_PKG dependencies on DUAL

Line 176: FROM sys.dual;

172: BEGIN
173:
174: SELECT csi_fa_headers_s.nextval
175: INTO l_interface_header_id
176: FROM sys.dual;
177:
178: csi_fa_headers_pkg.INSERT_ROW (
179: X_ROWID => l_rowid,
180: X_INTERFACE_HEADER_ID => l_interface_header_id,

Line 202: FROM sys.dual;

198: LOOP
199:
200: SELECT csi_fa_transactions_s.nextval
201: INTO l_interface_line_id
202: FROM sys.dual;
203:
204: csi_fa_transactions_pkg.INSERT_ROW (
205: X_ROWID => l_rowid,
206: X_INTERFACE_LINE_ID => l_interface_line_id,

Line 403: FROM sys.dual;

399: BEGIN
400:
401: SELECT fnd_profile.value('apps_framework_agent')||'/OA_HTML/OA.jsp?OAFunc=CSE_OANF_FA_SEARCH'
402: INTO l_ib_url
403: FROM sys.dual;
404:
405: x_ib_url := l_ib_url;
406:
407: END ib_url;

Line 427: FROM sys.dual;

423: debug('send mail');
424:
425: SELECT csi_wf_item_key_number_s.nextval
426: INTO l_item_key_seq
427: FROM sys.dual;
428:
429: l_item_key := l_item_type||'-'||l_item_key_seq;
430:
431: debug('item key : '||l_item_key);