APPS.HR_SECURITY_UTILS dependencies on PER_SECURITY_PROFILES

Line 54: security_profile_id per_security_profiles.security_profile_id%type,

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

Line 55: security_profile_name per_security_profiles.security_profile_name%type ) ;

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

Line 84: from per_security_profiles sp,

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