APPS.BIS_TRUNCATE_EMPTY_MV_LOG_PKG dependencies on FND_CONCURRENT_REQUESTS

Line 18: from bis_request_set_objects bis, fnd_request_sets fnd , fnd_concurrent_requests cr

14: return number
15: IS
16: CURSOR rs_running IS
17: select distinct bis.request_set_name Name, cr.phase_code Phase, cr.request_id request, cr.requested_start_date s_date
18: from bis_request_set_objects bis, fnd_request_sets fnd , fnd_concurrent_requests cr
19: where bis.request_set_name = fnd.request_set_name
20: and bis.set_app_id = fnd.application_id
21: and cr.phase_code = 'R'
22: and to_char(fnd.application_id) = cr.argument1

Line 29: FROM fnd_concurrent_programs prog, fnd_concurrent_requests req, bis_obj_properties obj

25: rs_running_rec rs_running%rowtype;
26:
27: CURSOR mv_refresh_prog IS
28: SELECT obj.object_name Name, req.request_id request
29: FROM fnd_concurrent_programs prog, fnd_concurrent_requests req, bis_obj_properties obj
30: WHERE (prog.concurrent_program_name = 'BIS_MV_REFRESH_STANDALONE' OR prog.concurrent_program_name = 'BIS_MV_REFRESH')
31: AND prog.application_id = 191
32: AND prog.concurrent_program_id = req.concurrent_program_id
33: AND req.phase_code = 'R'