DBA Data[Home] [Help]

APPS.CSF_PLANBOARD_TASKS dependencies on FND_LOOKUPS

Line 319: FND_LOOKUPS LKP

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'
323: AND RES.RESOURCE_ID = RR.ROLE_RESOURCE_ID

Line 336: FND_LOOKUPS LKP

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
340: AND LKP.LOOKUP_TYPE = 'JTF_RS_ROLE_TYPE'