APPS.PER_DELETE_UNWANTED_SEC_PROF dependencies on FND_USER

Line 129: (p_user_id IN fnd_user.user_id%TYPE) IS

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
132: WHERE user_id = p_user_id
133: AND sysdate BETWEEN start_date

Line 131: FROM fnd_user

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
132: WHERE user_id = p_user_id
133: AND sysdate BETWEEN start_date
134: AND nvl (end_date
135: ,hr_general.end_of_time);

Line 577: (p_user_id IN fnd_user.user_id%TYPE) IS

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
580: WHERE user_id = p_user_id
581: AND sysdate BETWEEN start_date

Line 579: FROM fnd_user

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
580: WHERE user_id = p_user_id
581: AND sysdate BETWEEN start_date
582: AND nvl (end_date
583: ,hr_general.end_of_time);

Line 805: (p_user_id IN fnd_user.user_id%TYPE) IS

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
808: WHERE user_id = p_user_id
809: AND sysdate BETWEEN start_date

Line 807: FROM fnd_user

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
808: WHERE user_id = p_user_id
809: AND sysdate BETWEEN start_date
810: AND nvl (end_date
811: ,hr_general.end_of_time);