APPS.JTF_AUTH_SECURITY_PKG dependencies on JTF_AUTH_PERMISSIONS_B

Line 24: FROM JTF_AUTH_PERMISSIONS_B A,

20: l_domain_name := UPPER(p_domain_name);
21: l_permission_name := p_permission_name;
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,

Line 89: from JTF_AUTH_PERMISSIONS_B

85: app_exception.raise_exception;
86: end if;
87:
88: select count(*) into cnt
89: from JTF_AUTH_PERMISSIONS_B
90: where PERMISSION_NAME=PERM_NAME;
91:
92: if cnt=0 then
93: fnd_message.set_name('JTF', 'JTF-1062');

Line 100: JTF_AUTH_PERMISSIONS_B B,

96:
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

Line 116: from JTF_AUTH_PRINCIPALS_B A, JTF_AUTH_PERMISSIONS_B B

112: LAST_UPDATED_BY, LAST_UPDATE_DATE,
113: APPLICATION_ID,OBJECT_VERSION_NUMBER)
114: select jtf_auth_s1.nextval, A.JTF_AUTH_PRINCIPAL_ID, B.JTF_AUTH_PERMISSION_ID,
115: 1,0, 0, SYSDATE, 0, SYSDATE, APP_ID,1
116: from JTF_AUTH_PRINCIPALS_B A, JTF_AUTH_PERMISSIONS_B B
117: where A.PRINCIPAL_NAME=U_ROLE_NAME and
118: B.PERMISSION_NAME=PERM_NAME and
119: A.IS_USER_FLAG=0;
120: