DBA Data[Home] [Help]

APPS.JTF_TTY_NA_WF dependencies on JTF_RS_ROLES_VL

Line 93: , JTF_RS_ROLES_VL RLV

89: select NAR.RSC_GROUP_ID, NAR.RESOURCE_ID, RLV.ROLE_ID, NAR.RSC_ROLE_CODE
90: from JTF_TTY_NAMED_ACCTS NA
91: , JTF_TTY_TERR_GRP_ACCTS TGA
92: , JTF_TTY_NAMED_ACCT_RSC NAR
93: , JTF_RS_ROLES_VL RLV
94: where NA.NAMED_ACCOUNT_ID = TGA.NAMED_ACCOUNT_ID
95: AND TGA.TERR_GROUP_ACCOUNT_ID = NAR.TERR_GROUP_ACCOUNT_ID
96: AND RLV.ROLE_CODE = NAR.RSC_ROLE_CODE
97: AND NA.NAMED_ACCOUNT_ID = c_named_account_id