1032: if z_security_groups_enabled then
1033:
1034: select max(lt.security_group_id)
1035: into retval 1036: from fnd_lookup_types lt 1037: where lt.view_application_id = lookup_security_group.view_application_id
1038: and lt.lookup_type = lookup_security_group.lookup_type
1039: and lt.security_group_id in (0,
1040: to_number(decode(substrb(userenv('CLIENT_INFO'),55,1),