APPS.JTF_AUTH_SECURITY_PKG dependencies on JTF_AUTH_ROLE_PERMS

Line 26: JTF_AUTH_ROLE_PERMS C,

22:
23: SELECT COUNT(*) INTO l_cnt
24: FROM JTF_AUTH_PERMISSIONS_B A,
25: JTF_AUTH_PRINCIPAL_MAPS B,
26: JTF_AUTH_ROLE_PERMS C,
27: JTF_AUTH_PRINCIPALS_B D,
28: JTF_AUTH_PRINCIPALS_B E,
29: JTF_AUTH_DOMAINS_B F
30: WHERE D.PRINCIPAL_NAME = l_user_name

Line 101: JTF_AUTH_ROLE_PERMS C

97:
98: select count(*) into cnt
99: from JTF_AUTH_PRINCIPALS_B A,
100: JTF_AUTH_PERMISSIONS_B B,
101: JTF_AUTH_ROLE_PERMS C
102: where A.JTF_AUTH_PRINCIPAL_ID = C.JTF_AUTH_PRINCIPAL_ID and
103: B.JTF_AUTH_PERMISSION_ID = C.JTF_AUTH_PERMISSION_ID and
104: A.PRINCIPAL_NAME=U_ROLE_NAME and
105: B.PERMISSION_NAME=PERM_NAME and

Line 109: insert into JTF_AUTH_ROLE_PERMS(JTF_AUTH_ROLE_PERMISSION_ID, JTF_AUTH_PRINCIPAL_ID, JTF_AUTH_PERMISSION_ID,

105: B.PERMISSION_NAME=PERM_NAME and
106: A.IS_USER_FLAG=0;
107:
108: if cnt=0 then
109: insert into JTF_AUTH_ROLE_PERMS(JTF_AUTH_ROLE_PERMISSION_ID, JTF_AUTH_PRINCIPAL_ID, JTF_AUTH_PERMISSION_ID,
110: POSITIVE_FLAG, OWNERBASED_FLAG,
111: CREATED_BY, CREATION_DATE,
112: LAST_UPDATED_BY, LAST_UPDATE_DATE,
113: APPLICATION_ID,OBJECT_VERSION_NUMBER)