DBA Data[Home] [Help]

APPS.AS_GAR_PROPOSALS_PUB dependencies on JTF_TERR_DENORM_RULES_ALL

Line 258: JTF_TERR_DENORM_RULES_ALL rules,

254: CURSOR count_res_proposal
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'

Line 526: JTF_TERR_DENORM_RULES_ALL rules,

522: CURSOR count_res_proposal
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'