DBA Data[Home] [Help]

APPS.CSF_PLANBOARD_TASKS dependencies on JTF_RS_ROLES_B

Line 292: JTF_RS_ROLES_B D

288: A.RESOURCE_TYPE
289: FROM CSF_SELECTED_RESOURCES_V A,
290: JTF_RS_DEFRESROLES_VL B,
291: JTF_RS_ALL_RESOURCES_VL C,
292: JTF_RS_ROLES_B D
293: WHERE B.ROLE_RESOURCE_ID=A.RESOURCE_ID
294: AND C.RESOURCE_ID = B.ROLE_RESOURCE_ID
295: AND C.RESOURCE_TYPE =A.RESOURCE_TYPE
296: AND D.ROLE_ID = B.ROLE_ID

Line 318: JTF_RS_ROLES_B RL ,

314: RES.RESOURCE_ID,
315: RES.RESOURCE_TYPE
316: FROM CSF_SELECTED_RESOURCES_V RES ,
317: JTF_RS_ROLE_RELATIONS RR,
318: JTF_RS_ROLES_B RL ,
319: FND_LOOKUPS LKP
320: WHERE RR.ROLE_ID = RL.ROLE_ID
321: AND RL.ROLE_TYPE_CODE = LKP.LOOKUP_CODE
322: AND LKP.LOOKUP_TYPE = 'JTF_RS_ROLE_TYPE'

Line 335: JTF_RS_ROLES_B RL ,

331: A.RESOURCE_ID ,
332: A.RESOURCE_TYPE
333: FROM CSF_SELECTED_RESOURCES_V A,
334: JTF_RS_ROLE_RELATIONS RR,
335: JTF_RS_ROLES_B RL ,
336: FND_LOOKUPS LKP
337: WHERE RR.ROLE_RESOURCE_ID = A.RESOURCE_ID
338: AND RL.ROLE_ID = RR.ROLE_ID
339: AND LKP.LOOKUP_CODE = RL.ROLE_TYPE_CODE