DBA Data[Home] [Help]

APPS.AS_GAR_QOT_PUB dependencies on JTF_TERR_RSC_ALL

Line 279: FROM JTF_TERR_RSC_ALL rsc,

275:
276: CURSOR count_res_quotes
277: IS
278: SELECT count(*)
279: FROM JTF_TERR_RSC_ALL rsc,
280: JTF_TERR_DENORM_RULES_ALL rules,
281: JTF_TERR_RSC_ACCESS_ALL acc
282: WHERE rules.terr_id = rsc.terr_id
283: AND rsc.resource_type = 'RS_TEAM'

Line 547: FROM JTF_TERR_RSC_ALL rsc,

543:
544: CURSOR count_res_quotes
545: IS
546: SELECT count(*)
547: FROM JTF_TERR_RSC_ALL rsc,
548: JTF_TERR_DENORM_RULES_ALL rules,
549: JTF_TERR_RSC_ACCESS_ALL acc
550: WHERE rules.terr_id = rsc.terr_id
551: AND rsc.resource_type = 'RS_GROUP'