APPS.BIS_SUBMIT_REQUESTSET dependencies on FND_CONCURRENT_PROGRAMS

Line 212: fnd_concurrent_programs b

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
216: and a.conc_program_name <>'BSC_REFRESH_SUMMARY_IND'

Line 235: fnd_concurrent_programs bb

231: -- aa.program_application_id program_application_id,
232: -- aa.concurrent_program_id concurrent_program_id
233: from
234: fnd_concurrent_requests aa,
235: fnd_concurrent_programs bb
236: where bb.concurrent_program_name='BIS_MV_REFRESH'
237: and bb.application_id=191
238: and aa.program_application_id=bb.application_id
239: and aa.concurrent_program_id=bb.concurrent_program_id

Line 252: fnd_concurrent_programs b

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'
256: and a.CONC_APP_ID=b.application_id

Line 267: fnd_concurrent_programs bb

263: -- aa.program_application_id program_application_id,
264: -- aa.concurrent_program_id concurrent_program_id
265: from
266: fnd_concurrent_requests aa,
267: fnd_concurrent_programs bb
268: where bb.concurrent_program_name='BSC_REFRESH_SUMMARY_IND'
269: and bb.application_id=271
270: and aa.program_application_id=bb.application_id
271: and aa.concurrent_program_id=bb.concurrent_program_id

Line 416: fnd_concurrent_programs b

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')
420: and a.enabled_flag='Y'

Line 800: fnd_concurrent_programs bb

796: Select
797: max(aa.actual_completion_date) last_refresh_date
798: from
799: fnd_concurrent_requests aa,
800: fnd_concurrent_programs bb
801: where bb.concurrent_program_name='BSC_REFRESH_SUMMARY_IND'
802: and bb.application_id=271
803: and aa.program_application_id=bb.application_id
804: and aa.concurrent_program_id=bb.concurrent_program_id

Line 1029: fnd_concurrent_programs b

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'
1033: and a.CONC_APP_ID=b.application_id