APPS.QPR_DASHBOARD_UTIL dependencies on DUAL

Line 68: SELECT QPR_DASHBOARD_MASTER_S.NEXTVAL into n_dashboard_id FROM DUAL;

64: END IF;
65: END LOOP;
66:
67:
68: SELECT QPR_DASHBOARD_MASTER_S.NEXTVAL into n_dashboard_id FROM DUAL;
69: Populate_Dashboard_Details(p_user_id,p_plan_id,l_dashboard_id,n_dashboard_id,l_dsb_table,l_return_status);
70:
71:
72: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 79: and language = (select USERENV('Lang') from dual);

75: SELECT dashboard_name,source_lang
76: INTO l_dashboard_name,l_source_lang
77: FROM QPR_DASHBOARD_MASTER_TL
78: WHERE dashboard_id = l_dashboard_id
79: and language = (select USERENV('Lang') from dual);
80:
81:
82: UPDATE QPR_DASHBOARD_MASTER_B
83: SET dashboard_id = n_dashboard_id

Line 166: SELECT QPR_DASHBOARD_DETAILS_S.NEXTVAL INTO n_dashboard_detail_id FROM DUAL;

162: WHERE report_type_header_id = l_content_id
163: and user_id = p_user_id
164: and plan_id = p_plan_id
165: and Seeded_Report_Flag = 'Y';
166: SELECT QPR_DASHBOARD_DETAILS_S.NEXTVAL INTO n_dashboard_detail_id FROM DUAL;
167:
168: UPDATE QPR_DASHBOARD_DETAILS
169: SET DASHBOARD_ID = n_dashboard_id,
170: DASHBOARD_DETAIL_ID = n_dashboard_detail_id,

Line 290: DUAL;

286:
287: FOR i in 0..(p_dsb_table.count - 1)
288: LOOP
289: SELECT QPR_DASHBOARD_DETAILS_S.NEXTVAL INTO l_dashboard_detail_id FROM
290: DUAL;
291: INSERT INTO QPR_DASHBOARD_DETAILS
292: ( DASHBOARD_DETAIL_ID
293: , DASHBOARD_ID
294: , ROW_NUMBER