APPS.BIV_RT_TASK_BLOG_PKG dependencies on DUAL

Line 96: into l_order_by from dual;

92: '4', 'to_number(col8) desc',
93: '5', 'to_number(col10) desc',
94: '6', 'to_number(col12) desc',
95: 'col2 asc')
96: into l_order_by from dual;
97:
98: x_sql_sttmnt := '
99: insert into biv_tmp_rt2 (report_code, rowno, col1, col2,
100: col4, col6, col8, col10, col12, session_id)

Line 284: from dual;

280: select decode(biv_core_pkg.g_srt_by,'2','to_number(col4) desc',
281: '3','to_number(col6) desc',
282: 'col2 asc')
283: into l_order_by
284: from dual;
285: l_sql_sttmnt := '
286: insert into biv_tmp_rt2(report_code,rowno, col1,col2,
287: col4, col6,session_id)
288: select ''BIV_RT_TASK_ACTIVITY'', rownum,