APPS.JTF_AUTH_SECURITY_PKG dependencies on JTF_AUTH_PRINCIPALS_B

Line 27: JTF_AUTH_PRINCIPALS_B D,

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
31: AND D.JTF_AUTH_PRINCIPAL_ID =B.JTF_AUTH_PRINCIPAL_ID

Line 28: JTF_AUTH_PRINCIPALS_B E,

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
31: AND D.JTF_AUTH_PRINCIPAL_ID =B.JTF_AUTH_PRINCIPAL_ID
32: AND B.JTF_AUTH_PARENT_PRINCIPAL_ID = E.JTF_AUTH_PRINCIPAL_ID

Line 80: from jtf_auth_principals_b

76: begin
77: U_ROLE_NAME := UPPER(ROLE_NAME);
78:
79: select count(*) into cnt
80: from jtf_auth_principals_b
81: where principal_name=U_ROLE_NAME and is_user_flag=0;
82:
83: if cnt=0 then
84: fnd_message.set_name('JTF', 'JTF-1061');

Line 99: from JTF_AUTH_PRINCIPALS_B A,

95: end if;
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

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: