DBA Data[Home] [Help]

APPS.ASO_PA_APR_WF_PVT dependencies on FND_USER

Line 637: l_fnd_user_id number;

633: l_forward_displayname VARCHAR2 (240);
634: l_start_block_activity varchar2(1);
635: l_has_fyi_app varchar2(1);
636: l_approver_index NUMBER;
637: l_fnd_user_id number;
638:
639: begin
640: IF (funcmode='RUN') THEN
641:

Line 1645: -- FND User Record.

1641: l_person_id := l_orig_system_id;
1642:
1643: ELSIF (l_orig_system = ame_util.fnduserorigsystem)
1644: THEN
1645: -- FND User Record.
1646: l_fnd_usr_id:=l_orig_system_id;
1647:
1648: END IF;
1649:

Line 2399: FROM fnd_user

2395:
2396: CURSOR get_user_id ( c_employee_id NUMBER)
2397: IS
2398: SELECT user_id
2399: FROM fnd_user
2400: WHERE employee_id = c_employee_id;
2401:
2402:
2403:

Line 2776: FROM aso_apr_obj_approvals aoa, fnd_user fu

2772: CURSOR get_requestor (
2773: l_approval_id NUMBER
2774: ) IS
2775: SELECT aoa.requester_userid, fu.employee_id
2776: FROM aso_apr_obj_approvals aoa, fnd_user fu
2777: WHERE object_approval_id = l_approval_id
2778: AND aoa.requester_userid = fu.user_id
2779: AND SYSDATE BETWEEN fu.start_date AND NVL (
2780: fu.end_date,

Line 2785: FROM fnd_user

2781: SYSDATE
2782: );
2783: CURSOR get_username(l_user_id NUMBER) IS
2784: SELECT user_name
2785: FROM fnd_user
2786: WHERE user_id = l_user_id;
2787:
2788: l_object_id number;
2789: type approverrec is record