34: l_eff_date DATE;
35: l_oc_profile_value VARCHAR2(10);
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
224: l_eff_date DATE;
225:
226: CURSOR cur_get_employee (v_user_id IN NUMBER) IS
227: SELECT employee_id
228: FROM fnd_user
229: WHERE user_id = v_user_id ;
230:
231: CURSOR cur_get_org (v_org_id number) IS
232: