48: --
49: type bg_sp is record (
50: business_group_id per_business_groups.business_group_id%type,
51: bg_name per_business_groups.name%type,
52: security_profile_id per_security_profiles.security_profile_id%type,
53: security_profile_name per_security_profiles.security_profile_name%type ) ;
54:
55: l_site_value varchar2(80) ;
56: l_appl_value varchar2(80) ;
49: type bg_sp is record (
50: business_group_id per_business_groups.business_group_id%type,
51: bg_name per_business_groups.name%type,
52: security_profile_id per_security_profiles.security_profile_id%type,
53: security_profile_name per_security_profiles.security_profile_name%type ) ;
54:
55: l_site_value varchar2(80) ;
56: l_appl_value varchar2(80) ;
57: l_resp_value varchar2(80) ;
79: select bg.business_group_id,
80: bg.name,
81: sp.security_profile_id,
82: sp.security_profile_name
83: from per_security_profiles sp,
84: per_business_groups bg
85: where sp.security_profile_id = nvl(p_sp_id,sp.security_profile_id)
86: and sp.business_group_id = nvl(p_bg_id,sp.business_group_id)
87: and sp.business_group_id = bg.business_group_id