48:
49: PROCEDURE check_profile_options IS
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:
49: PROCEDURE check_profile_options IS
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) ;
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
89: and sp.view_all_flag = decode(bg.business_group_id,null,