DBA Data[Home] [Help]

APPS.AS_GAR_PROPOSALS_PUB dependencies on JTF_TERR_RSC_ACCESS_ALL

Line 259: JTF_TERR_RSC_ACCESS_ALL acc

255: IS
256: SELECT count(*)
257: FROM JTF_TERR_RSC_ALL rsc,
258: JTF_TERR_DENORM_RULES_ALL rules,
259: JTF_TERR_RSC_ACCESS_ALL acc
260: WHERE rules.terr_id = rsc.terr_id
261: AND rsc.resource_type = 'RS_TEAM'
262: AND acc.access_type = 'PROPOSAL'
263: AND rules.source_id = -1001

Line 527: JTF_TERR_RSC_ACCESS_ALL acc

523: IS
524: SELECT count(*)
525: FROM JTF_TERR_RSC_ALL rsc,
526: JTF_TERR_DENORM_RULES_ALL rules,
527: JTF_TERR_RSC_ACCESS_ALL acc
528: WHERE rules.terr_id = rsc.terr_id
529: AND rsc.resource_type = 'RS_GROUP'
530: AND acc.access_type = 'PROPOSAL'
531: AND rules.source_id = -1001