760: select count(*)
761: into l_num_pending_requests
762: from fnd_concurrent_programs cp,
763: fnd_application ap,
764: fnd_concurrent_requests cr
765: where ap.application_short_name = l_CS_appsname
766: and cp.concurrent_program_name = l_sync_idx_progname
767: and cp.application_id = ap.application_id
768: and cr.concurrent_program_id = cp.concurrent_program_id
828: select count(*)
829: into l_num_pending_requests
830: from fnd_concurrent_programs cp,
831: fnd_application ap,
832: fnd_concurrent_requests cr
833: where ap.application_short_name = l_CS_appsname
834: and cp.concurrent_program_name = l_sync_idx_progname
835: and cp.application_id = ap.application_id
836: and cr.concurrent_program_id = cp.concurrent_program_id