APPS.PO_WF_REQ_NOTIFICATION dependencies on FND_USER

Line 1930: l_user_name fnd_user.user_name%TYPE;

1926: order by 1 asc; /* bug 3090563 reverse display order */
1927: l_notification_id number;
1928:
1929: /* Bug 2788683 start */
1930: l_user_name fnd_user.user_name%TYPE;
1931: l_vendor_name hz_parties.party_name%TYPE;
1932: l_party_name hz_parties.party_name%TYPE;
1933: /* Bug 2788683 end */
1934:

Line 2025: FROM fnd_user fu,

2021: */
2022: IF l_history.employee_id IS NULL THEN
2023: SELECT fu.user_name, hp.party_name
2024: INTO l_user_name, l_party_name
2025: FROM fnd_user fu,
2026: hz_parties hp
2027: WHERE hp.party_id = fu.customer_id
2028: AND fu.user_id = l_history.created_by;
2029:

Line 2076: FROM fnd_user fu,

2072: */
2073: IF l_history.employee_id IS NULL THEN
2074: SELECT fu.user_name, hp.party_name
2075: INTO l_user_name, l_party_name
2076: FROM fnd_user fu,
2077: hz_parties hp
2078: WHERE hp.party_id = fu.customer_id
2079: AND fu.user_id = l_history.created_by;
2080:

Line 2666: l_responder_id fnd_user.user_id%TYPE;

2662: l_doc_string varchar2(200);
2663: l_preparer_user_name varchar2(100);
2664:
2665: -- Context setting revamp
2666: l_responder_id fnd_user.user_id%TYPE;
2667: l_session_user_id NUMBER;
2668: l_session_resp_id NUMBER;
2669: l_session_appl_id NUMBER;
2670: l_preparer_resp_id NUMBER;

Line 2861: FROM fnd_user fu,

2857:
2858:
2859: SELECT fu.USER_ID
2860: INTO l_responder_id
2861: FROM fnd_user fu,
2862: wf_notifications wfn
2863: WHERE wfn.notification_id = l_nid
2864: AND wfn.original_recipient = fu.user_name;
2865: