DBA Data[Home] [Help]

APPS.IEX_COLLECTORS_TO_RESOURCE dependencies on JTF_RS_ROLE_RELATIONS_VL

Line 509: FROM JTF_RS_ROLE_RELATIONS_VL JRR,

505:
506: -- Check whether Collections Role Exists for the Resource and Create if Role does'nt exist.
507: BEGIN
508: SELECT ROLE_ID INTO L_CHECK_ROLE
509: FROM JTF_RS_ROLE_RELATIONS_VL JRR,
510: JTF_RS_RESOURCE_EXTNS JRE
511: WHERE
512: JRE.SOURCE_ID = L_EMPLOYEE_ID(I)
513: AND JRR.ROLE_RESOURCE_ID = JRE.RESOURCE_ID