DBA Data[Home] [Help]

APPS.AS_GAR_OPPTYS_PUB dependencies on JTF_TERR_RSC_ALL

Line 283: FROM JTF_TERR_RSC_ALL rsc,

279:
280: CURSOR count_res_oppor
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'

Line 549: FROM JTF_TERR_RSC_ALL rsc,

545:
546: CURSOR count_res_oppor
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'