188:
189: SELECT min(fcr.request_id)
190: into l_reqid_count
191: FROM fnd_concurrent_requests fcr,
192: fnd_concurrent_programs fcp
193: WHERE fcp.concurrent_program_name IN ('CSTSLAUM')
194: AND fcp.application_id = 702
195: AND fcr.concurrent_program_id = fcp.concurrent_program_id
196: AND fcr.program_application_id = fcp.application_id
476:
477: SELECT min(fcr.request_id)
478: into l_reqid_count
479: FROM fnd_concurrent_requests fcr,
480: fnd_concurrent_programs fcp
481: WHERE fcp.concurrent_program_name = l_program_name
482: AND fcp.application_id = l_prg_appid
483: AND fcr.concurrent_program_id = fcp.concurrent_program_id
484: AND fcr.program_application_id = fcp.application_id