APPS.PQH_WF dependencies on FND_USER

Line 637: , fnd_user usr

633: SELECT '1-USR-TO' order_by
634: , rht.routing_history_id routing_history_id
635: , user_name user_name
636: FROM pqh_routing_history rht
637: , fnd_user usr
638: WHERE usr.user_id = rht.forwarded_by_user_id
639: AND transaction_category_id = p_transaction_category_id
640: AND transaction_id = p_transaction_id
641: AND user_action_cd <> 'TIMEOUT'

Line 673: , fnd_user usr

669: SELECT '4-USR-BY'
670: , rht.routing_history_id
671: , user_name
672: FROM pqh_routing_history rht
673: , fnd_user usr
674: WHERE usr.user_id = rht.forwarded_by_user_id
675: AND rht.forwarded_to_user_id IS NULL
676: AND transaction_category_id = p_transaction_category_id
677: AND transaction_id = p_transaction_id

Line 774: , fnd_user usr

770: l_user VARCHAR2(100);
771: CURSOR c_rht IS
772: SELECT user_name
773: FROM pqh_routing_history rht
774: , fnd_user usr
775: WHERE usr.user_id = rht.forwarded_by_user_id
776: AND transaction_category_id = p_transaction_category_id
777: AND transaction_id = p_transaction_id
778: AND approval_cd = 'APPROVED'

Line 836: , fnd_user usr

832: , forwarded_by_position_id
833: , forwarded_by_user_id
834: , forwarded_by_role_id
835: FROM pqh_routing_history rht
836: , fnd_user usr
837: WHERE usr.user_id = rht.forwarded_by_user_id
838: AND routing_history_id = (
839: SELECT MIN(routing_history_id)
840: FROM pqh_routing_history

Line 1576: l_route_to_user FND_USER.USER_NAME%TYPE;

1572: l_post_txn_function VARCHAR2(61);
1573: l_future_action_cd VARCHAR2(30);
1574: l_post_style_cd VARCHAR2(30);
1575: l_short_name VARCHAR2(30);
1576: l_route_to_user FND_USER.USER_NAME%TYPE;
1577: l_wf_not_running BOOLEAN;
1578: l_apply_error_mesg VARCHAR2(200) := 'No_Error';
1579: l_apply_error_num VARCHAR2(30) := '0' ;
1580: l_routing_history_id NUMBER;

Line 2092: l_user fnd_user.user_name%TYPE;

2088: -- r_get_fyi c_get_fyi%ROWTYPE;
2089: l_user_action_cd pqh_routing_history.user_action_cd%TYPE;
2090: l_transaction_id pqh_routing_history.transaction_id%TYPE;
2091: l_transaction_category_id pqh_routing_history.transaction_category_id%TYPE;
2092: l_user fnd_user.user_name%TYPE;
2093: l_transaction_status VARCHAR2(30);
2094: BEGIN
2095: hr_utility.set_location(l_proc || ' Entering',10);
2096: hr_utility.set_location(l_proc || ' FuncMode ' || funcmode, 20);

Line 2557: l_user fnd_user.user_name%TYPE;

2553: l_proc VARCHAR2(61) := g_package || 'process_response';
2554: l_transaction_category_id NUMBER;
2555: l_transaction_id NUMBER;
2556: l_response VARCHAR2(30);
2557: l_user fnd_user.user_name%TYPE;
2558: l_user_action_cd VARCHAR2(30);
2559: l_requestor VARCHAR2(30);
2560: l_current_user VARCHAR2(30);
2561: BEGIN

Line 2721: , fnd_user fu

2717:
2718: cursor c_get_assignment (p_user_id NUMBER) IS
2719: SELECT asg.assignment_id,asg.position_id
2720: FROM per_all_assignments asg
2721: , fnd_user fu
2722: WHERE asg.person_id = fu.employee_id
2723: AND fu.user_id = p_user_id
2724: AND asg.primary_flag = 'Y';
2725:

Line 2927: from per_all_people_f per, fnd_user usr

2923: end;
2924: function get_person_name(p_user_id in number default null,
2925: p_assignment_id in number default null) return varchar2 is
2926: cursor c1 is select full_name
2927: from per_all_people_f per, fnd_user usr
2928: where per.person_id = usr.employee_id
2929: and usr.user_id = p_user_id;
2930: cursor c2 is select full_name
2931: from per_all_assignments_f asg, per_all_people_f per