Announcements for Payroll and OTL can now be found in the Announcements - Payroll and OTL - EBS (MOSC) subcategory. Follow to be sure you don't miss a thing!
OTL: Getting Project and Task for an Employee
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
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
0