eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBU_DAC_CRITERIA_PKG dependencies on JTF_AUTH_PRINCIPALS_B

Line 17: (select JTF_AUTH_PRINCIPAL_ID from jtf_auth_principals_b where JTF_AUTH_PRINCIPAL_ID

13: customer_id integer;
14: company_name varchar(360);
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

Line 23: and jtf_auth_principals_b.DAC_ROLE_FLAG ='1')) and jtf_dac_role_perm_crit.PERMISSION_NAME = PermissionName;

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);
27: company_id := IBU_HOME_PAGE_PVT.get_company_id_from_user(UserID);

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 67: from jtf_auth_principals_b where jtf_auth_principals_b.PRINCIPAL_NAME = PRINCIPAL_NAME)

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