DBA Data[Home] [Help]

APPS.AS_GAR_ACCOUNTS_PUB dependencies on JTF_TERR_RSC_ACCESS_ALL

Line 324: JTF_TERR_RSC_ACCESS_ALL acc

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'
327: AND acc.access_type = 'ACCOUNT'
328: AND rules.source_id = -1001

Line 592: JTF_TERR_RSC_ACCESS_ALL acc

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'
595: AND acc.access_type = 'ACCOUNT'
596: AND rules.source_id = -1001