APPS.PER_DELETE_UNWANTED_SEC_PROF dependencies on FND_RESPONSIBILITY

Line 121: (p_responsibility_id IN fnd_responsibility.responsibility_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'
123: FROM fnd_responsibility
124: WHERE responsibility_id = p_responsibility_id
125: AND sysdate BETWEEN start_date

Line 123: FROM fnd_responsibility

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'
123: FROM fnd_responsibility
124: WHERE responsibility_id = p_responsibility_id
125: AND sysdate BETWEEN start_date
126: AND nvl (end_date
127: ,hr_general.end_of_time);

Line 197: l_responsibility_id fnd_responsibility.responsibility_id%TYPE;

193: )
194: AND level_id = '10001'
195: AND profile_option_value = to_char (p_security_profile_id);
196: l_security_profile_id per_security_profiles.security_profile_id%TYPE;
197: l_responsibility_id fnd_responsibility.responsibility_id%TYPE;
198: l_valid varchar2(1);
199: l_active varchar2(1);
200: l_profile_counter positive DEFAULT 1;
201: l_proc varchar2(100);

Line 569: (p_responsibility_id IN fnd_responsibility.responsibility_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'
571: FROM fnd_responsibility
572: WHERE responsibility_id = p_responsibility_id
573: AND sysdate BETWEEN start_date

Line 571: FROM fnd_responsibility

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'
571: FROM fnd_responsibility
572: WHERE responsibility_id = p_responsibility_id
573: AND sysdate BETWEEN start_date
574: AND nvl (end_date
575: ,hr_general.end_of_time);

Line 645: l_responsibility_id fnd_responsibility.responsibility_id%TYPE;

641: )
642: AND level_id = '10001'
643: AND profile_option_value = to_char (p_security_profile_id);
644: l_security_profile_id per_security_profiles.security_profile_id%TYPE;
645: l_responsibility_id fnd_responsibility.responsibility_id%TYPE;
646: l_valid varchar2(1);
647: l_active varchar2(1);
648: l_profile_counter positive DEFAULT 1;
649: l_proc varchar2(100);

Line 797: (p_responsibility_id IN fnd_responsibility.responsibility_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'
799: FROM fnd_responsibility
800: WHERE responsibility_id = p_responsibility_id
801: AND sysdate BETWEEN start_date

Line 799: FROM fnd_responsibility

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'
799: FROM fnd_responsibility
800: WHERE responsibility_id = p_responsibility_id
801: AND sysdate BETWEEN start_date
802: AND nvl (end_date
803: ,hr_general.end_of_time);

Line 873: l_responsibility_id fnd_responsibility.responsibility_id%TYPE;

869: )
870: AND level_id = '10001'
871: AND profile_option_value = to_char (p_security_profile_id);
872: l_security_profile_id per_security_profiles.security_profile_id%TYPE;
873: l_responsibility_id fnd_responsibility.responsibility_id%TYPE;
874: l_valid varchar2(1);
875: l_active varchar2(1);
876: l_proc varchar2(100);
877: BEGIN