APPS.HR_SEC3_UPDATE dependencies on PER_BUSINESS_GROUPS

Line 50: business_group_id per_business_groups.business_group_id%type,

46:
47: PROCEDURE set_profile_options IS
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:

Line 51: bg_name per_business_groups.name%type,

47: PROCEDURE set_profile_options IS
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) ;

Line 84: per_business_groups bg

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
88: and sp.view_all_flag = decode(bg.business_group_id,null,