DBA Data[Home] [Help]

APPS.OKE_K_ACCESS_RULES_PKG2 dependencies on PA_ROLE_CONTROLS

Line 590: , PA_Role_Controls RC

586: CURSOR c IS
587: SELECT PRT.Project_Role_ID Role_ID
588: , PRT.Meaning Role_Name
589: FROM PA_Project_Role_Types PRT
590: , PA_Role_Controls RC
591: WHERE RC.Project_Role_ID = PRT.Project_Role_ID
592: AND RC.Role_Control_Code = 'ALLOW_AS_CONTRACT_MEMBER'
593: AND PRT.Freeze_Rules_Flag = 'Y'
594: AND PRT.Project_Role_ID = nvl(X_Role_ID , PRT.Project_Role_ID)