DBA Data[Home] [Help]

APPS.PJM_INTEGRATION_PROJ_MFG dependencies on FND_USER

Line 182: from fnd_user fu

178: c_project_manager varchar2(240):='';
179:
180: cursor cu_project_manager is
181: select fu.user_name project_manager
182: from fnd_user fu
183: ,pa_project_players ppp
184: ,pa_projects_all ppa
185: where fu.employee_id =ppp.person_id
186: and nvl(fu.end_date,sysdate) >=sysdate

Line 209: from fnd_user fu

205: c_task_manager varchar2(240):='';
206:
207: cursor cu_task_manager is
208: select fu.user_name task_manager
209: from fnd_user fu
210: ,pa_tasks pt
211: where fu.employee_id =pt.task_manager_person_id
212: and nvl(fu.end_date,sysdate) >=sysdate
213: and pt.task_id = pn_task_id