APPS.BSC_SEC_UTILITY dependencies on DUAL

Line 17: from dual

13: l_sql varchar2(2000);
14: l_dummy varchar2(1);
15: cursor c_view_exist is
16: select '1'
17: from dual
18: where exists
19: (select '1'
20: from user_objects
21: where object_name=p_level_view_name

Line 462: from dual

458:
459: function has_access_level(p_tab_id in varchar2) return varchar2 is
460: cursor c_exist is
461: select 'Y'
462: from dual
463: where exists (select TAB_ID from bsc_sys_com_dim_levels where tab_id=p_tab_id);
464: l_dummy varchar2(1);
465: begin
466: l_dummy:=null;

Line 482: from dual

478:
479: function exist_user_list_access(p_resp_id in number,p_tab_id in number) return varchar2 is
480: cursor exist_user_list_access is
481: select 'Y'
482: from dual
483: where exists
484: (select 'Y' from bsc_user_list_access
485: where RESPONSIBILITY_ID=p_resp_id
486: and TAB_ID=p_tab_id);

Line 537: from dual

533: l_last_update_date DATE := nvl(P_LAST_UPDATE_DATE, l_Sysdate);
534:
535: cursor row_exists is
536: select 'Y'
537: from dual
538: where exists
539: (select 'Y'
540: from bsc_user_tab_access
541: where responsibility_id=p_resp_id

Line 721: from dual

717: l_last_update_date DATE := nvl(P_LAST_UPDATE_DATE, l_Sysdate);
718:
719: cursor row_exists is
720: select 'Y'
721: from dual
722: where exists
723: (select 'Y'
724: from bsc_user_kpi_access
725: where responsibility_id=p_resp_id