APPS.HRFASTANSWERS dependencies on PER_SECURITY_PROFILES

Line 115: from per_security_profiles spr

111: , cp_secg_id Number )
112: is
113: select spr.view_all_organizations_flag
114: , spr.organization_structure_id
115: from per_security_profiles spr
116: , per_sec_profile_assignments spa
117: where spr.security_profile_id = spa.security_profile_id
118: and spa.user_id = cp_user_id
119: and spa.responsibility_id = cp_resp_id

Line 130: from per_security_profiles

126: ( cp_security_profile_id number )
127: is
128: select view_all_organizations_flag
129: ,organization_structure_id
130: from per_security_profiles
131: where security_profile_id = cp_security_profile_id;
132:
133: cursor c_primary
134: ( cp_bus_id Number )

Line 144: l_security_profile_id per_security_profiles.security_profile_id%type;

140:
141: l_all_org Varchar2(80);
142: l_bus_id Number := null;
143: l_enable_sg varchar2(1);
144: l_security_profile_id per_security_profiles.security_profile_id%type;
145: l_str_id Number := null;
146:
147: l_user_id Number := FND_Global.User_Id;
148: l_resp_id Number := FND_Global.Resp_Id;