107: and trunc(nvl(end_date, to_date('31-12-4712', 'DD-MM-YYYY')));
108:
109: CURSOR login_id IS
110: SELECT employee_id
111: FROM fnd_user
112: WHERE user_id = FND_GLOBAL.user_id;
113:
114: BEGIN
115:
210: WHERE full_name = p_person_name;
211:
212: CURSOR login_id IS
213: SELECT employee_id
214: FROM fnd_user
215: WHERE user_id = FND_GLOBAL.user_id;
216:
217: BEGIN
218: