APPS.OKL_AM_ASSET_RETURN_WF dependencies on PER_PEOPLE_F

Line 374: per_people_f ppf

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

Line 1134: per_people_f ppf

1130: -- get the sender email address
1131: CURSOR c_agent_csr (c_agent_id NUMBER) IS
1132: SELECT nvl(ppf.email_address , fu.email_address) email
1133: FROM fnd_user fu,
1134: per_people_f ppf
1135: WHERE fu.employee_id = ppf.person_id (+)
1136: AND fu.user_id = c_agent_id;
1137: l_from_email VARCHAR2(100);
1138: l_to_email VARCHAR2(100);

Line 1365: per_people_f ppf

1361: -- get the sender email address
1362: CURSOR c_agent_csr (c_agent_id NUMBER) IS
1363: SELECT nvl(ppf.email_address , fu.email_address) email
1364: FROM fnd_user fu,
1365: per_people_f ppf
1366: WHERE fu.employee_id = ppf.person_id (+)
1367: AND fu.user_id = c_agent_id;
1368: l_from_email VARCHAR2(100);
1369: l_to_email VARCHAR2(100);