APPS.BIS_PMV_UTIL dependencies on DUAL

Line 149: from dual;

145: x_current_date := fnd_date.date_to_chardate(SYSDATE);
146:
147: select to_char(SYSDATE, 'HH24')
148: into x_current_hour
149: from dual;
150:
151: select to_char(SYSDATE, 'MI')
152: into x_current_minute
153: from dual;

Line 153: from dual;

149: from dual;
150:
151: select to_char(SYSDATE, 'MI')
152: into x_current_minute
153: from dual;
154:
155: end getCurrentDateTime;
156:
157: --Bug Fix 2503143 nbarik 03/sep/2002

Line 194: l_function := 'select '||l_function||' from dual';

190: where region_code = pRegionCode;
191:
192: l_function := substr(l_function, instr(l_function, '[')+1, instr(l_function, ']')-instr(l_function,'[')-1);
193: if l_function is not null then
194: l_function := 'select '||l_function||' from dual';
195: begin
196: execute immediate l_function into l_append_title;
197: exception
198: when others then

Line 771: lSQL := 'select bis_portlet_trends.getPortalPageId(:1) from dual';

767:
768: lPageId number;
769: lSQL varchar2(2000);
770: begin
771: lSQL := 'select bis_portlet_trends.getPortalPageId(:1) from dual';
772: begin
773: execute immediate lSQL into lPageId using pPageName ;
774: exception
775: when others then lPageId := null;