19: BEGIN
20: -- if requests exist short circuit return
21: select count(*)
22: into num_pend 23: from fnd_application a, 24: fnd_concurrent_programs p,
25: fnd_concurrent_requests r
26: where a.application_short_name = 'FND'
27: and a.application_id = p.application_id