DBA Data[Home] [Help]

APPS.IBE_UTIL dependencies on JTF_AUTH_PRINCIPALS_B

Line 335: JTF_AUTH_PRINCIPALS_B D,

331: CURSOR c_get_permission(l_user_name VARCHAR2,l_permission VARCHAR2) IS
332: SELECT 'Y' FROM JTF_AUTH_PERMISSIONS_B A,
333: JTF_AUTH_PRINCIPAL_MAPS B,
334: JTF_AUTH_ROLE_PERMS C,
335: JTF_AUTH_PRINCIPALS_B D,
336: JTF_AUTH_PRINCIPALS_B E,
337: JTF_AUTH_DOMAINS_B F
338: WHERE D.PRINCIPAL_NAME = l_user_name AND D.IS_USER_FLAG = 1 AND
339: D.JTF_AUTH_PRINCIPAL_ID = B.JTF_AUTH_PRINCIPAL_ID AND

Line 336: JTF_AUTH_PRINCIPALS_B E,

332: SELECT 'Y' FROM JTF_AUTH_PERMISSIONS_B A,
333: JTF_AUTH_PRINCIPAL_MAPS B,
334: JTF_AUTH_ROLE_PERMS C,
335: JTF_AUTH_PRINCIPALS_B D,
336: JTF_AUTH_PRINCIPALS_B E,
337: JTF_AUTH_DOMAINS_B F
338: WHERE D.PRINCIPAL_NAME = l_user_name AND D.IS_USER_FLAG = 1 AND
339: D.JTF_AUTH_PRINCIPAL_ID = B.JTF_AUTH_PRINCIPAL_ID AND
340: B.JTF_AUTH_PARENT_PRINCIPAL_ID=E.JTF_AUTH_PRINCIPAL_ID AND