859: -- concurrent program requests there are.
860: select count(*)
861: into l_num_pending_requests
862: from fnd_concurrent_programs cp,
863: fnd_application ap,
864: fnd_concurrent_requests cr
865: where ap.application_short_name = l_CS_appsname
866: and cp.concurrent_program_name = l_sync_idx_progname
867: and cp.application_id = ap.application_id
956: -- concurrent program requests there are.
957: select count(*)
958: into l_num_pending_requests
959: from fnd_concurrent_programs cp,
960: fnd_application ap,
961: fnd_concurrent_requests cr
962: where ap.application_short_name = l_CS_appsname
963: and cp.concurrent_program_name = l_sync_idx_progname
964: and cp.application_id = ap.application_id