34: l_eff_date DATE;
35:
36: CURSOR cur_get_employee (v_user_id IN NUMBER) IS
37: SELECT employee_id
38: FROM fnd_user
39: WHERE user_id = v_user_id ;
40: CURSOR cur_get_oper_cert (v_org_id IN NUMBER,
41: v_object_id IN NUMBER,
42: v_object_type IN NUMBER ) IS
227: l_eff_date DATE;
228:
229: CURSOR cur_get_employee (v_user_id IN NUMBER) IS
230: SELECT employee_id
231: FROM fnd_user
232: WHERE user_id = v_user_id ;
233:
234: CURSOR cur_get_org (v_org_id number) IS
235: