APPS.PER_DELETE_UNWANTED_SEC_PROF dependencies on HR_GENERAL

Line 127: ,hr_general.end_of_time);

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);
128: CURSOR c_user
129: (p_user_id IN fnd_user.user_id%TYPE) IS
130: SELECT 'Y'
131: FROM fnd_user

Line 135: ,hr_general.end_of_time);

131: FROM fnd_user
132: WHERE user_id = p_user_id
133: AND sysdate BETWEEN start_date
134: AND nvl (end_date
135: ,hr_general.end_of_time);
136: CURSOR c_sec_profile
137: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
138: SELECT level_value
139: FROM fnd_profile_option_values

Line 575: ,hr_general.end_of_time);

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);
576: CURSOR c_user
577: (p_user_id IN fnd_user.user_id%TYPE) IS
578: SELECT 'Y'
579: FROM fnd_user

Line 583: ,hr_general.end_of_time);

579: FROM fnd_user
580: WHERE user_id = p_user_id
581: AND sysdate BETWEEN start_date
582: AND nvl (end_date
583: ,hr_general.end_of_time);
584: CURSOR c_sec_profile
585: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
586: SELECT level_value
587: FROM fnd_profile_option_values

Line 803: ,hr_general.end_of_time);

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);
804: CURSOR c_user
805: (p_user_id IN fnd_user.user_id%TYPE) IS
806: SELECT 'Y'
807: FROM fnd_user

Line 811: ,hr_general.end_of_time);

807: FROM fnd_user
808: WHERE user_id = p_user_id
809: AND sysdate BETWEEN start_date
810: AND nvl (end_date
811: ,hr_general.end_of_time);
812: CURSOR c_sec_profile
813: (p_security_profile_id IN per_security_profiles.security_profile_id%TYPE) IS
814: SELECT level_value
815: FROM fnd_profile_option_values