DBA Data[Home] [Help]

APPS.AS_GAR_OPPTYS_PUB dependencies on JTF_TERR_RSC_ACCESS_ALL

Line 285: JTF_TERR_RSC_ACCESS_ALL acc

281: IS
282: SELECT count(*)
283: FROM JTF_TERR_RSC_ALL rsc,
284: JTF_TERR_DENORM_RULES_ALL rules,
285: JTF_TERR_RSC_ACCESS_ALL acc
286: WHERE rules.terr_id = rsc.terr_id
287: AND rsc.resource_type = 'RS_TEAM'
288: AND acc.access_type = 'OPPOR'
289: AND rules.source_id = -1001

Line 551: JTF_TERR_RSC_ACCESS_ALL acc

547: IS
548: SELECT count(*)
549: FROM JTF_TERR_RSC_ALL rsc,
550: JTF_TERR_DENORM_RULES_ALL rules,
551: JTF_TERR_RSC_ACCESS_ALL acc
552: WHERE rules.terr_id = rsc.terr_id
553: AND rsc.resource_type = 'RS_GROUP'
554: AND acc.access_type = 'OPPOR'
555: AND rules.source_id = -1001