APPS.IBU_DAC_CRITERIA_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 16

    select property_value from jtf_dac_role_perm_crit where jtf_dac_role_perm_crit.JTF_AUTH_PRINCIPAL_ID in
    (select JTF_AUTH_PRINCIPAL_ID from jtf_auth_principals_b where JTF_AUTH_PRINCIPAL_ID
    in (
    select unique(JTF_AUTH_PRINCIPAL_ID) from jtf_auth_role_perms
    where jtf_auth_role_perms.JTF_AUTH_PERMISSION_ID in(
    select JTF_AUTH_PERMISSION_ID
    from jtf_auth_read_perms where jtf_auth_read_perms.jtf_auth_principal_name  = UserName )
    and jtf_auth_principals_b.DAC_ROLE_FLAG ='1')) and jtf_dac_role_perm_crit.PERMISSION_NAME = PermissionName;

Line: 65

    select jtf_auth_read_perms.JTF_AUTH_PERMISSION_ID from jtf_auth_read_perms where
    jtf_auth_read_perms.JTF_AUTH_PRINCIPAL_NAME in (select jtf_auth_principals_b.PRINCIPAL_NAME
    from jtf_auth_principals_b where jtf_auth_principals_b.PRINCIPAL_NAME = PRINCIPAL_NAME)
    and jtf_auth_read_perms.JTF_AUTH_PERMISSION_NAME = PermissionName;