DBA Data[Home] [Help]

APPS.AS_GAR_OPPTYS_PUB dependencies on JTF_TERR_DENORM_RULES_ALL

Line 284: JTF_TERR_DENORM_RULES_ALL rules,

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'
288: AND acc.access_type = 'OPPOR'

Line 550: JTF_TERR_DENORM_RULES_ALL rules,

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'
554: AND acc.access_type = 'OPPOR'