DBA Data[Home] [Help]

APPS.AS_GAR_LEADS_PUB dependencies on JTF_TERR_DENORM_RULES_ALL

Line 279: JTF_TERR_DENORM_RULES_ALL rules,

275: CURSOR count_res_lead
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'

Line 545: JTF_TERR_DENORM_RULES_ALL rules,

541: CURSOR count_res_lead
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'