758: -- Detect how many Pending, but not scheduled, KM Sync-Index
759: -- concurrent program requests there are.
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
826: -- Detect how many Pending, but not scheduled, KM Sync-Index
827: -- concurrent program requests there are.
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