DBA Data[Home] [Help]

APPS.AS_GAR_LEADS_PUB dependencies on JTF_TERR_RSC_ACCESS_ALL

Line 280: JTF_TERR_RSC_ACCESS_ALL acc

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'
284: AND rules.source_id = -1001

Line 546: JTF_TERR_RSC_ACCESS_ALL acc

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'
550: AND rules.source_id = -1001