APPS.PO_REQAPPROVAL_FINDAPPRV1 dependencies on FND_USER

Line 1384: ** user is a valid employee and also belongs to fnd_users

1380: */
1381:
1382: /* Bug# 1301432: kagarwal
1383: ** Desc: When validating the forward to username we need to verify that the
1384: ** user is a valid employee and also belongs to fnd_users
1385: **
1386: ** We need to change the Fix of Bug#1134100.
1387: ** The ORIG_SYSTEM_ID in wf_roles returns employee number for username
1388: ** associated with an employee and fnd_user.user_id for username not

Line 1388: ** associated with an employee and fnd_user.user_id for username not

1384: ** user is a valid employee and also belongs to fnd_users
1385: **
1386: ** We need to change the Fix of Bug#1134100.
1387: ** The ORIG_SYSTEM_ID in wf_roles returns employee number for username
1388: ** associated with an employee and fnd_user.user_id for username not
1389: ** associated with an employee
1390: **
1391: ** We can do away with the check of wf_roles but it will help us
1392: ** identify if the users have setup issue. Also the check from

Line 1399: FROM FND_USER FND, PO_WORKFORCE_CURRENT_X HR --

1395: */
1396:
1397: cursor C2(username varchar2) is
1398: SELECT HR.PERSON_ID
1399: FROM FND_USER FND, PO_WORKFORCE_CURRENT_X HR --
1400: WHERE FND.USER_NAME = username
1401: AND FND.EMPLOYEE_ID = HR.PERSON_ID
1402: AND ROWNUM = 1;
1403:

Line 1400: WHERE FND.USER_NAME = username

1396:
1397: cursor C2(username varchar2) is
1398: SELECT HR.PERSON_ID
1399: FROM FND_USER FND, PO_WORKFORCE_CURRENT_X HR --
1400: WHERE FND.USER_NAME = username
1401: AND FND.EMPLOYEE_ID = HR.PERSON_ID
1402: AND ROWNUM = 1;
1403:
1404: -- check_emp_id number;