APPS.PER_DELETE_UNWANTED_SEC_PROF dependencies on PER_SEC_PROFILE_ASSIGNMENTS

Line 118: FROM per_sec_profile_assignments

114: AND view_all_flag <> 'Y';
115: CURSOR c_sec_profile_assignments
116: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
117: SELECT responsibility_id
118: FROM per_sec_profile_assignments
119: WHERE security_profile_id = p_security_profile_id;
120: CURSOR c_responsibility
121: (p_responsibility_id IN fnd_responsibility.responsibility_id%TYPE) IS
122: SELECT 'Y'

Line 526: FROM per_sec_profile_assignments

522: ,100);
523:
524: BEGIN
525: DELETE
526: FROM per_sec_profile_assignments
527: WHERE security_profile_id = l_security_profile_id;
528: EXCEPTION
529: WHEN no_data_found THEN
530: NULL;

Line 566: FROM per_sec_profile_assignments

562: AND view_all_flag <> 'Y';
563: CURSOR c_sec_profile_assignments
564: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
565: SELECT responsibility_id
566: FROM per_sec_profile_assignments
567: WHERE security_profile_id = p_security_profile_id;
568: CURSOR c_responsibility
569: (p_responsibility_id IN fnd_responsibility.responsibility_id%TYPE) IS
570: SELECT 'Y'

Line 794: FROM per_sec_profile_assignments

790: AND security_profile_id = p_security_profile_id;
791: CURSOR c_sec_profile_assignments
792: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
793: SELECT responsibility_id
794: FROM per_sec_profile_assignments
795: WHERE security_profile_id = p_security_profile_id;
796: CURSOR c_responsibility
797: (p_responsibility_id IN fnd_responsibility.responsibility_id%TYPE) IS
798: SELECT 'Y'