APPS.BIS_SUBMIT_REQUESTSET dependencies on DUAL

Line 17: from dual

13:
14: function get_parameter_flag(p_program_name varchar2, p_app_id number) return varchar2 is
15: cursor c_parameter is
16: select 'Y'
17: from dual
18: where exists
19: (select descriptive_flexfield_name
20: from fnd_descr_flex_column_usages
21: where application_id=p_app_id

Line 248: from dual

244: ---group by aa.program_application_id,aa.concurrent_program_id;
245:
246: cursor c_mv_has_program is
247: select 'Y'
248: from dual
249: where exists
250: (select 'Y'
251: from bis_obj_prog_linkages a,
252: fnd_concurrent_programs b

Line 413: from dual

409: ----This is better than return 'Not available' we had before
410: cursor c_obj_has_program(p_obj_type varchar2, p_obj_name varchar2,p_refresh_mode varchar2)
411: is
412: select 'Y'
413: from dual
414: where exists (select 'Y'
415: from bis_obj_prog_linkages a,
416: fnd_concurrent_programs b
417: where a.object_name=p_obj_name

Line 708: refresh date program for individual object

704: -----The following code is changed for enhancement 3426538
705: if l_object_name is not null then ----the page exists in RSG
706: /** Bug 4257955. Return whatever date in bis_Obj_properties
707: The logic of '01-01-1900' is moved to update last
708: refresh date program for individual object
709: if l_date is null then
710: l_date:=to_date('01-01-1900','DD-MM-YYYY');
711: end if;
712: **/

Line 1026: from dual

1022: ----Please note we don't check program refresh mode in this cursor
1023: cursor c_obj_has_program(p_obj_type varchar2, p_obj_name varchar2)
1024: is
1025: select 'Y'
1026: from dual
1027: where exists (select 'Y'
1028: from bis_obj_prog_linkages a,
1029: fnd_concurrent_programs b
1030: where a.object_name=p_obj_name