APPS.HR_SECURITY_UTILS dependencies on PER_BUSINESS_GROUPS

Line 52: business_group_id per_business_groups.business_group_id%type,

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:

Line 53: bg_name per_business_groups.name%type,

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) ;

Line 85: per_business_groups bg

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,