APPS.ASO_APR_WF_PVT dependencies on FND_USER

Line 1427: FROM aso_apr_obj_approvals aoa, fnd_user fu

1423: CURSOR get_requestor (
1424: l_approval_id NUMBER
1425: ) IS
1426: SELECT aoa.requester_userid, fu.employee_id
1427: FROM aso_apr_obj_approvals aoa, fnd_user fu
1428: WHERE object_approval_id = l_approval_id
1429: AND aoa.requester_userid = fu.user_id
1430: AND SYSDATE BETWEEN fu.start_date AND NVL (
1431: fu.end_date,

Line 1436: FROM fnd_user

1432: SYSDATE
1433: );
1434: CURSOR get_username(l_user_id NUMBER) IS
1435: SELECT user_name
1436: FROM fnd_user
1437: WHERE user_id = l_user_id;
1438:
1439: BEGIN
1440: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 2274: FROM fnd_user

2270:
2271: CURSOR get_user_id ( c_employee_id NUMBER)
2272: IS
2273: SELECT user_id
2274: FROM fnd_user
2275: WHERE employee_id = c_employee_id;
2276:
2277:
2278:

Line 2743: from fnd_user

2739: WHERE object_approval_id = c_object_approval_id;
2740:
2741: cursor get_employee_id(l_user_id NUMBER) IS
2742: select employee_id
2743: from fnd_user
2744: where user_id = l_user_id;
2745:
2746:
2747: BEGIN