[Home] [Help]
397: l_source_code VARCHAR2(30);
398:
399: CURSOR update_cur IS
400: SELECT user_name
401: FROM fnd_user_view
402: WHERE user_id = l_update_by;
403:
404:
405: BEGIN
901: l_update_name VARCHAR2(100);
902:
903: CURSOR update_cur IS
904: SELECT user_name
905: FROM fnd_user_view
906: WHERE user_id = l_update_by;
907:
908: BEGIN
909:
3338:
3339:
3340: CURSOR update_cur IS
3341: SELECT user_name
3342: FROM fnd_user_view
3343: WHERE user_id = l_update_by;
3344:
3345: CURSOR op_det IS
3346: SELECT bdp.department_id, nvl(bso.count_point_type, 1) count_point_type,
3529:
3530:
3531: CURSOR update_cur IS
3532: SELECT user_name
3533: FROM fnd_user_view
3534: WHERE user_id = l_update_by;
3535:
3536:
3537: CURSOR res_det IS