APPS.IBU_DAC_CRITERIA_PKG dependencies on JTF_AUTH_ROLE_PERMS

Line 19: select unique(JTF_AUTH_PRINCIPAL_ID) from jtf_auth_role_perms

15: cursor l_types_csr is
16: select property_value from jtf_dac_role_perm_crit where jtf_dac_role_perm_crit.JTF_AUTH_PRINCIPAL_ID in
17: (select JTF_AUTH_PRINCIPAL_ID from jtf_auth_principals_b where JTF_AUTH_PRINCIPAL_ID
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;

Line 20: where jtf_auth_role_perms.JTF_AUTH_PERMISSION_ID in(

16: select property_value from jtf_dac_role_perm_crit where jtf_dac_role_perm_crit.JTF_AUTH_PRINCIPAL_ID in
17: (select JTF_AUTH_PRINCIPAL_ID from jtf_auth_principals_b where JTF_AUTH_PRINCIPAL_ID
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