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