479: l_comments VARCHAR2(2000);
480:
481: CURSOR get_user_id_csr IS
482: SELECT user_id 483: FROM fnd_user 484: WHERE user_name = l_approver_username;
485: BEGIN
486:
487: IF (funcmode = 'RUN') THEN
Line 578: FROM fnd_user
574: aname => 'CREATOR_USERNAME');
575: BEGIN
576: SELECT user_id
577: into l_creator_user_id 578: FROM fnd_user 579: WHERE user_name = l_creator_username;
580: EXCEPTION
581: WHEN OTHERS THEN
582: result := 'ERROR';