[Home] [Help]
1522: */
1523:
1524: /* Bug# 1301432: kagarwal
1525: ** Desc: When validating the forward to username we need to verify that the
1526: ** user is a valid employee and also belongs to fnd_users
1527: **
1528: ** We need to change the Fix of Bug#1134100.
1529: ** The ORIG_SYSTEM_ID in wf_roles returns employee number for username
1530: ** associated with an employee and fnd_user.user_id for username not
1526: ** user is a valid employee and also belongs to fnd_users
1527: **
1528: ** We need to change the Fix of Bug#1134100.
1529: ** The ORIG_SYSTEM_ID in wf_roles returns employee number for username
1530: ** associated with an employee and fnd_user.user_id for username not
1531: ** associated with an employee
1532: **
1533: ** We can do away with the check of wf_roles but it will help us
1534: ** identify if the users have setup issue. Also the check from
1537: */
1538:
1539: cursor C2(username varchar2) is
1540: SELECT HR.PERSON_ID
1541: FROM FND_USER FND, PO_WORKFORCE_CURRENT_X HR --
1543: AND FND.EMPLOYEE_ID = HR.PERSON_ID
1544: AND ROWNUM = 1;
1545:
1538:
1539: cursor C2(username varchar2) is
1540: SELECT HR.PERSON_ID
1541: FROM FND_USER FND, PO_WORKFORCE_CURRENT_X HR --
1542: WHERE FND.USER_NAME = username
1543: AND FND.EMPLOYEE_ID = HR.PERSON_ID
1544: AND ROWNUM = 1;
1545:
1546: -- check_emp_id number;