275: CURSOR count_res_lead
276: IS
277: SELECT count(*)
278: FROM JTF_TERR_RSC_ALL rsc,
279: JTF_TERR_DENORM_RULES_ALL rules,
280: JTF_TERR_RSC_ACCESS_ALL acc
281: WHERE rules.terr_id = rsc.terr_id
282: AND rsc.resource_type = 'RS_TEAM'
283: AND acc.access_type = 'LEAD'
541: CURSOR count_res_lead
542: IS
543: SELECT count(*)
544: FROM JTF_TERR_RSC_ALL rsc,
545: JTF_TERR_DENORM_RULES_ALL rules,
546: JTF_TERR_RSC_ACCESS_ALL acc
547: WHERE rules.terr_id = rsc.terr_id
548: AND rsc.resource_type = 'RS_GROUP'
549: AND acc.access_type = 'LEAD'