APPS.BIS_IMPL_OPT_PKG dependencies on DUAL

Line 190: from dual

186: function check_top_node(p_object_type in varchar2,p_object_name in varchar2) return varchar2 is
187: l_dummy varchar2(1);
188: cursor c_top_node is
189: select 'Y'
190: from dual
191: where not exists
192: (select 'Y'
193: from bis_obj_dependency
194: where depend_object_name=p_object_name

Line 313: select 'Y' from dual

309: ---added for enhancement 3999465 and 4422645.
310: FUNCTION report_in_impl_pages(p_report_name varchar2) return varchar2
311: is
312: cursor report_in_impl_pages is
313: select 'Y' from dual
314: where exists
315: (select 'Y'
316: from
317: (SELECT distinct object_name

Line 685: from dual

681: v_ret_code VARCHAR2(10);
682:
683: CURSOR c_enabled_dep_objects IS
684: select 'Y'
685: from dual
686: where exists
687: (SElECT depend_object_name
688: FROM bis_obj_dependency objdep
689: WHERE objdep.object_name = p_report_name

Line 696: from dual

692:
693: --added for bug 4532066
694: CURSOR c_linked_programs IS
695: select 'Y'
696: from dual
697: where exists
698: (SElECT object_name
699: FROM bis_obj_prog_linkages
700: WHERE object_name = p_report_name

Line 822: from dual

818: l_dummy varchar2(1);
819:
820: cursor l_check_impl is
821: select 'Y'
822: from dual
823: where exists
824: (select 'Y' from bis_obj_properties
825: where implementation_flag='Y'
826: and object_type in ('PAGE','REPORT')