APPS.PO_WF_PO_NOTIFICATION dependencies on FND_USER

Line 1049: l_user_name fnd_user.user_name%TYPE;

1045: curr_len NUMBER := 0;
1046: prior_len NUMBER := 0;
1047:
1048: /* Bug 2788683 start */
1049: l_user_name fnd_user.user_name%TYPE;
1050: l_vendor_name hz_parties.party_name%TYPE;
1051: l_party_name hz_parties.party_name%TYPE;
1052: /* Bug 2788683 end */
1053:

Line 1235: FROM fnd_user fu,

1231: SELECT fu.user_name,
1232: hp.party_name
1233: INTO l_user_name,
1234: l_party_name
1235: FROM fnd_user fu,
1236: hz_parties hp
1237: WHERE hp.party_id = fu.customer_id
1238: AND fu.user_id = l_created_by_tbl(i);
1239:

Line 1310: FROM fnd_user fu,

1306: */
1307: IF l_employee_id_tbl(i) IS NULL THEN
1308: SELECT fu.user_name, hp.party_name
1309: INTO l_user_name, l_party_name
1310: FROM fnd_user fu,
1311: hz_parties hp
1312: WHERE hp.party_id = fu.customer_id
1313: AND fu.user_id = l_created_by_tbl(i);
1314:

Line 1347: l_responder_id fnd_user.user_id%TYPE;

1343: funcmode in varchar2,
1344: resultout in out NOCOPY varchar2) is
1345:
1346: -- Context setting revamp
1347: l_responder_id fnd_user.user_id%TYPE;
1348: l_session_user_id NUMBER;
1349: l_session_resp_id NUMBER;
1350: l_session_appl_id NUMBER;
1351: l_preparer_resp_id NUMBER;

Line 1366: FROM fnd_user fu,

1362: l_nid := WF_ENGINE.context_nid;
1363:
1364: SELECT fu.USER_ID
1365: INTO l_responder_id
1366: FROM fnd_user fu,
1367: wf_notifications wfn
1368: WHERE wfn.notification_id = l_nid
1369: AND wfn.original_recipient = fu.user_name;
1370: