APPS.OKL_AM_ASSET_RETURN_WF dependencies on FND_USER

Line 373: FROM fnd_user fu,

369:
370: -- get the sender email address
371: CURSOR c_agent_csr (c_agent_id NUMBER) IS
372: SELECT nvl(ppf.email_address , fu.email_address) email
373: FROM fnd_user fu,
374: per_people_f ppf
375: WHERE fu.employee_id = ppf.person_id (+)
376: AND fu.user_id = c_agent_id;
377: l_from_email VARCHAR2(100);

Line 1178: FROM fnd_user fu,

1174:
1175: -- get the sender email address
1176: CURSOR c_agent_csr (c_agent_id NUMBER) IS
1177: SELECT nvl(ppf.email_address , fu.email_address) email
1178: FROM fnd_user fu,
1179: per_people_f ppf
1180: WHERE fu.employee_id = ppf.person_id (+)
1181: AND fu.user_id = c_agent_id;
1182: l_from_email VARCHAR2(100);

Line 1409: FROM fnd_user fu,

1405:
1406: -- get the sender email address
1407: CURSOR c_agent_csr (c_agent_id NUMBER) IS
1408: SELECT nvl(ppf.email_address , fu.email_address) email
1409: FROM fnd_user fu,
1410: per_people_f ppf
1411: WHERE fu.employee_id = ppf.person_id (+)
1412: AND fu.user_id = c_agent_id;
1413: l_from_email VARCHAR2(100);