APPS.OKC_ARTWF_PVT dependencies on FND_USER

Line 812: FROM fnd_user

808: --Fix for 6237128.Set null for notified when user is end-dated
809:
810: CURSOR c_usr (notified_usr in hr_organization_information.org_information3%TYPE) IS
811: SELECT user_name
812: FROM fnd_user
813: WHERE user_name = notified_usr
814: AND nvl(end_date, sysdate + 1) > sysdate;
815: valid_notified FND_USER.user_name%TYPE;
816: --end of fix

Line 815: valid_notified FND_USER.user_name%TYPE;

811: SELECT user_name
812: FROM fnd_user
813: WHERE user_name = notified_usr
814: AND nvl(end_date, sysdate + 1) > sysdate;
815: valid_notified FND_USER.user_name%TYPE;
816: --end of fix
817:
818: begin
819: counter := wf_engine.getItemAttrNumber(itemtype, itemkey, 'COUNTER$', false);

Line 1287: from fnd_user_view

1283: function user_name return varchar2
1284: is
1285: cursor c_usr is
1286: select user_name
1287: from fnd_user_view
1288: where user_id = fnd_global.user_id;
1289: user_name fnd_user_view.user_name%type;
1290: begin
1291: user_name := null;

Line 1289: user_name fnd_user_view.user_name%type;

1285: cursor c_usr is
1286: select user_name
1287: from fnd_user_view
1288: where user_id = fnd_global.user_id;
1289: user_name fnd_user_view.user_name%type;
1290: begin
1291: user_name := null;
1292: open c_usr;
1293: fetch c_usr into user_name;