DBA Data[Home] [Help]

APPS.BIS_SUBMIT_REQUESTSET dependencies on BIS_OBJ_PROG_LINKAGES

Line 211: bis_obj_prog_linkages a,

207: ( select distinct
208: b.application_id application_id,
209: b.CONCURRENT_PROGRAM_ID concurrent_program_id
210: from
211: bis_obj_prog_linkages a,
212: fnd_concurrent_programs b
213: where a.object_name=p_obj_name
214: and a.object_type=p_obj_type
215: and a.CONC_PROGRAM_NAME=b.concurrent_program_name

Line 251: from bis_obj_prog_linkages a,

247: select 'Y'
248: from dual
249: where exists
250: (select 'Y'
251: from bis_obj_prog_linkages a,
252: fnd_concurrent_programs b
253: where a.object_name=p_obj_name
254: and a.object_type='MV'
255: and a.enabled_flag='Y'

Line 415: from bis_obj_prog_linkages a,

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
418: and a.object_type=p_obj_type
419: and (a.refresh_mode=p_refresh_mode or a.refresh_mode='INIT_INCR')

Line 952: from bis_obj_prog_linkages

948: function has_loader_sum_prog(p_report_name in varchar2) return varchar2 is
949:
950: cursor c_report_program(p_report_name varchar2) is
951: select 'Y'
952: from bis_obj_prog_linkages
953: where object_name=p_report_name
954: and object_type='REPORT'
955: and CONC_PROGRAM_NAME='BSC_REFRESH_SUMMARY_IND';
956:

Line 1028: from bis_obj_prog_linkages a,

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
1031: and a.object_type=p_obj_type
1032: and a.enabled_flag='Y'