This discussion is archived
0 Replies Latest reply: Nov 5, 2012 2:42 AM by user488418 RSS

getting project and taks for a employee

user488418 Newbie
Currently Being Moderated
Hi,

I am trying to get all project for a employee whose user_name(in) is employee id with following query:


SELECT PALL.SEGMENT1, PALL.NAME FROM APPS.PA_PROJECT_ASSIGNMENTS PASS ,APPS.PA_PROJECTS_ALL PALL WHERE
pass.project_id = pall.project_id AND
PASS.RESOURCE_ID IN (SELECT RESOURCE_ID FROM APPS.PA_RESOURCES_DENORM WHERE PERSON_ID
IN (SELECT PERSON_ID FROM APPS.PER_ALL_PEOPLE_F WHERE EMPLOYEE_NUMBER= '205172'));

and following query for getting assign task

SELECT * FROM APPS.PA_TASKS WHERE PROJECT_ID = 2088;

Is above aproach is good or there is some TimeStore API function or procedure need to call

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points