0 Replies Latest reply: Nov 5, 2012 4:42 AM by user488418 RSS

    getting project and taks for a employee

    user488418
      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