APPS.IBU_DAC_CRITERIA_PKG dependencies on JTF_AUTH_READ_PERMS

Line 22: from jtf_auth_read_perms where jtf_auth_read_perms.jtf_auth_principal_name = UserName )

18: in (
19: select unique(JTF_AUTH_PRINCIPAL_ID) from jtf_auth_role_perms
20: where jtf_auth_role_perms.JTF_AUTH_PERMISSION_ID in(
21: select JTF_AUTH_PERMISSION_ID
22: from jtf_auth_read_perms where jtf_auth_read_perms.jtf_auth_principal_name = UserName )
23: and jtf_auth_principals_b.DAC_ROLE_FLAG ='1')) and jtf_dac_role_perm_crit.PERMISSION_NAME = PermissionName;
24: begin
25:
26: account_id := IBU_HOME_PAGE_PVT.get_account_id_from_user(UserID);

Line 65: select jtf_auth_read_perms.JTF_AUTH_PERMISSION_ID from jtf_auth_read_perms where

61: ) return boolean is
62: result varchar2(2000) := 'FALSE';
63: l_string varchar2(2000);
64: cursor l_types_csr is
65: select jtf_auth_read_perms.JTF_AUTH_PERMISSION_ID from jtf_auth_read_perms where
66: jtf_auth_read_perms.JTF_AUTH_PRINCIPAL_NAME in (select jtf_auth_principals_b.PRINCIPAL_NAME
67: from jtf_auth_principals_b where jtf_auth_principals_b.PRINCIPAL_NAME = PRINCIPAL_NAME)
68: and jtf_auth_read_perms.JTF_AUTH_PERMISSION_NAME = PermissionName;
69:

Line 66: jtf_auth_read_perms.JTF_AUTH_PRINCIPAL_NAME in (select jtf_auth_principals_b.PRINCIPAL_NAME

62: result varchar2(2000) := 'FALSE';
63: l_string varchar2(2000);
64: cursor l_types_csr is
65: select jtf_auth_read_perms.JTF_AUTH_PERMISSION_ID from jtf_auth_read_perms where
66: jtf_auth_read_perms.JTF_AUTH_PRINCIPAL_NAME in (select jtf_auth_principals_b.PRINCIPAL_NAME
67: from jtf_auth_principals_b where jtf_auth_principals_b.PRINCIPAL_NAME = PRINCIPAL_NAME)
68: and jtf_auth_read_perms.JTF_AUTH_PERMISSION_NAME = PermissionName;
69:
70: begin

Line 68: and jtf_auth_read_perms.JTF_AUTH_PERMISSION_NAME = PermissionName;

64: cursor l_types_csr is
65: select jtf_auth_read_perms.JTF_AUTH_PERMISSION_ID from jtf_auth_read_perms where
66: jtf_auth_read_perms.JTF_AUTH_PRINCIPAL_NAME in (select jtf_auth_principals_b.PRINCIPAL_NAME
67: from jtf_auth_principals_b where jtf_auth_principals_b.PRINCIPAL_NAME = PRINCIPAL_NAME)
68: and jtf_auth_read_perms.JTF_AUTH_PERMISSION_NAME = PermissionName;
69:
70: begin
71:
72: for rec in l_types_csr loop