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 2563: l_user fnd_user.user_name%TYPE;

2559: l_proc VARCHAR2(61) := g_package || 'process_response';
2560: l_transaction_category_id NUMBER;
2561: l_transaction_id NUMBER;
2562: l_response VARCHAR2(30);
2563: l_user fnd_user.user_name%TYPE;
2564: l_user_action_cd VARCHAR2(30);
2565: l_requestor VARCHAR2(30);
2566: l_current_user VARCHAR2(30);
2567: BEGIN

Line 2727: , fnd_user fu

2723:
2724: cursor c_get_assignment (p_user_id NUMBER) IS
2725: SELECT asg.assignment_id,asg.position_id
2726: FROM per_all_assignments asg
2727: , fnd_user fu
2728: WHERE asg.person_id = fu.employee_id
2729: AND fu.user_id = p_user_id
2730: AND asg.primary_flag = 'Y'
2731: AND asg.assignment_type = 'E'; -- added for bug 7708168

Line 2941: from per_all_people_f per, fnd_user usr

2937: end;
2938: function get_person_name(p_user_id in number default null,
2939: p_assignment_id in number default null) return varchar2 is
2940: cursor c1 is select full_name
2941: from per_all_people_f per, fnd_user usr
2942: where per.person_id = usr.employee_id
2943: and usr.user_id = p_user_id;
2944: cursor c2 is select full_name
2945: from per_all_assignments_f asg, per_all_people_f per