APPS.OKL_AM_QUOTES_WF dependencies on FND_USER

Line 1832: FROM fnd_user fu,

1828:
1829: -- get the sender email address
1830: CURSOR c_agent_csr (c_agent_id NUMBER) IS
1831: SELECT nvl(ppf.email_address , fu.email_address) email
1832: FROM fnd_user fu,
1833: per_people_f ppf
1834: WHERE fu.employee_id = ppf.person_id (+)
1835: AND fu.user_id = c_agent_id;
1836: l_from_email VARCHAR2(100);

Line 2339: FROM fnd_user fu,

2335: -- get the sender email address
2336: CURSOR c_requestor_csr (p_requestor_id NUMBER)
2337: IS
2338: SELECT nvl(ppf.email_address , fu.email_address) email
2339: FROM fnd_user fu,
2340: per_people_f ppf
2341: WHERE fu.employee_id = ppf.person_id (+)
2342: AND fu.user_id = p_requestor_id;
2343:

Line 2828: FROM fnd_user fu,

2824:
2825: -- get the sender email address
2826: CURSOR c_agent_csr (c_agent_id NUMBER) IS
2827: SELECT nvl(ppf.email_address , fu.email_address) email
2828: FROM fnd_user fu,
2829: per_people_f ppf
2830: WHERE fu.employee_id = ppf.person_id (+)
2831: AND fu.user_id = c_agent_id;
2832: l_from_email VARCHAR2(100);

Line 4113: FROM fnd_user fu,

4109:
4110: -- get the sender email address
4111: CURSOR c_agent_csr (c_agent_id NUMBER) IS
4112: SELECT nvl(ppf.email_address , fu.email_address) email
4113: FROM fnd_user fu,
4114: per_people_f ppf
4115: WHERE fu.employee_id = ppf.person_id (+)
4116: AND fu.user_id = c_agent_id;
4117: l_from_email VARCHAR2(100);

Line 4885: FROM fnd_user fu,

4881:
4882: -- get the sender email address
4883: CURSOR c_agent_csr (c_agent_id NUMBER) IS
4884: SELECT nvl(ppf.email_address , fu.email_address) email
4885: FROM fnd_user fu,
4886: per_people_f ppf
4887: WHERE fu.employee_id = ppf.person_id (+)
4888: AND fu.user_id = c_agent_id;
4889: