APPS.OKL_AM_QUOTES_WF dependencies on PER_PEOPLE_F

Line 1833: per_people_f ppf

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);
1837: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 2340: per_people_f ppf

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:
2344: l_from_email VARCHAR2(100);

Line 2829: per_people_f ppf

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);
2833: l_to_email VARCHAR2(100);

Line 4114: per_people_f ppf

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);
4118: l_to_email VARCHAR2(100);

Line 4886: per_people_f ppf

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:
4890: l_from_email VARCHAR2(100);