APPS.WSMPINVL dependencies on FND_USER

Line 1141: FROM fnd_user

1137:
1138: BEGIN
1139: SELECT 1
1140: into x_dummy
1141: FROM fnd_user
1142: WHERE user_id = crec.created_by
1143: AND sysdate between start_date
1144: and nvl(END_date, sysdate + 1);
1145:

Line 1319: FROM fnd_user

1315: BEGIN
1316: lProcLocation := 40;
1317: SELECT 1
1318: into x_dummy
1319: FROM fnd_user
1320: WHERE user_id = crec.last_updated_by
1321: AND sysdate between start_date
1322: and nvl(END_date, sysdate + 1);
1323:

Line 1608: FROM fnd_user

1604: BEGIN
1605: lprocLocation := 10;
1606: SELECT 1
1607: into x_dummy
1608: FROM fnd_user
1609: WHERE user_id = crec.created_by
1610: AND sysdate between start_date
1611: and nvl(END_date, sysdate + 1);
1612: EXCEPTION when others THEN

Line 1785: FROM fnd_user

1781:
1782: BEGIN
1783: SELECT 1
1784: into x_dummy
1785: FROM fnd_user
1786: WHERE user_id = crec.last_updated_by
1787: AND sysdate between start_date
1788: and nvl(END_date, sysdate + 1);
1789: EXCEPTION when others THEN

Line 2805: FROM fnd_user

2801: lProcLocation := 30;
2802: BEGIN
2803: SELECT 1
2804: into x_dummy
2805: FROM fnd_user
2806: WHERE user_id = x_created_by
2807: AND sysdate between start_date
2808: and nvl(END_date, sysdate + 1);
2809: EXCEPTION when others THEN

Line 2822: FROM fnd_user

2818: lProcLocation := 40;
2819: BEGIN
2820: SELECT 1
2821: into x_dummy
2822: FROM fnd_user
2823: WHERE user_id = x_last_updated_by
2824: AND sysdate between start_date
2825: and nvl(END_date, sysdate + 1);
2826: EXCEPTION when others THEN

Line 2840: FROM fnd_user_responsibility f,

2836: into x_dummy
2837: FROM dual
2838: WHERE exists (
2839: SELECT 1
2840: FROM fnd_user_responsibility f,
2841: fnd_responsibility_tl r
2842: WHERE r.responsibility_name like '%Inventory%'
2843: and r.responsibility_id = f.responsibility_id
2844: and f.user_id = x_created_by);