DBA Data[Home] [Help]

APPS.PJM_INTEGRATION_PROJ_MFG dependencies on FND_USER

Line 183: from fnd_user fu

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

Line 210: from fnd_user fu

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