APPS.HR_DELETE dependencies on PER_SECURITY_PROFILES

Line 2257: DELETE FROM per_security_profiles psp

2253: FROM hr_all_organization_units ou
2254: WHERE ou.business_group_id = p_business_group_id);
2255: --
2256: hr_utility.set_location('hr_delete.delete_security_list_for_bg',7);
2257: DELETE FROM per_security_profiles psp
2258: WHERE psp.business_group_id = p_business_group_id
2259: AND psp.view_all_flag = 'N';
2260: --
2261: hr_utility.set_location('hr_delete.delete_security_list_for_bg',8);

Line 2270: FROM per_security_profiles sp

2266: --
2267: hr_utility.set_location('hr_delete.delete_security_list_for_bg',9);
2268: DELETE FROM per_security_users psu
2269: WHERE psu.security_profile_id IN (SELECT sp.security_profile_id
2270: FROM per_security_profiles sp
2271: WHERE sp.business_group_id = p_business_group_id);
2272: --
2273: END delete_security_list_for_bg;
2274: --