DBA Data[Home] [Help]

APPS.AS_GAR_LEADS_PUB dependencies on JTF_TERR_RSC_ACCESS_ALL

Line 321: JTF_TERR_RSC_ACCESS_ALL acc

317: IS
318: SELECT count(*)
319: FROM JTF_TERR_RSC_ALL rsc,
320: JTF_TERR_DENORM_RULES_ALL rules,
321: JTF_TERR_RSC_ACCESS_ALL acc
322: WHERE rules.terr_id = rsc.terr_id
323: AND rsc.resource_type = 'RS_TEAM'
324: AND acc.access_type = 'LEAD'
325: AND rules.source_id = -1001

Line 587: JTF_TERR_RSC_ACCESS_ALL acc

583: IS
584: SELECT count(*)
585: FROM JTF_TERR_RSC_ALL rsc,
586: JTF_TERR_DENORM_RULES_ALL rules,
587: JTF_TERR_RSC_ACCESS_ALL acc
588: WHERE rules.terr_id = rsc.terr_id
589: AND rsc.resource_type = 'RS_GROUP'
590: AND acc.access_type = 'LEAD'
591: AND rules.source_id = -1001