219:
220: CURSOR c_user
221: IS
222: SELECT user_id
223: FROM fnd_user
224: WHERE TRUNC (SYSDATE) BETWEEN TRUNC (NVL (start_date, SYSDATE))
225: AND TRUNC (NVL (end_date, SYSDATE))
226: AND user_name = p_user_name;
227:
227:
228: CURSOR c_user_id
229: IS
230: SELECT user_id
231: FROM fnd_user
232: WHERE TRUNC (SYSDATE) BETWEEN TRUNC (NVL (start_date, SYSDATE))
233: AND TRUNC (NVL (end_date, SYSDATE))
234: AND user_id = x_user_id;
235: BEGIN