DBA Data[Home] [Help]

APPS.AS_GAR_ACCOUNTS_PUB dependencies on JTF_TERR_RSC_ALL

Line 322: FROM JTF_TERR_RSC_ALL rsc,

318:
319: CURSOR count_res_account
320: IS
321: SELECT count(*)
322: FROM JTF_TERR_RSC_ALL rsc,
323: JTF_TERR_DENORM_RULES_ALL rules,
324: JTF_TERR_RSC_ACCESS_ALL acc
325: WHERE rules.terr_id = rsc.terr_id
326: AND rsc.resource_type = 'RS_TEAM'

Line 590: FROM JTF_TERR_RSC_ALL rsc,

586:
587: CURSOR count_res_account
588: IS
589: SELECT count(*)
590: FROM JTF_TERR_RSC_ALL rsc,
591: JTF_TERR_DENORM_RULES_ALL rules,
592: JTF_TERR_RSC_ACCESS_ALL acc
593: WHERE rules.terr_id = rsc.terr_id
594: AND rsc.resource_type = 'RS_GROUP'