APPS.PA_TASKS_MAINT_UTILS dependencies on PA_PROJECT_PARTIES

Line 37: from pa_project_parties ppp

33: where upper(full_name) = upper(p_task_mgr_name)
34: and active = '*' -- for bug 3245820
35: and person_id in
36: ( select RESOURCE_source_ID
37: from pa_project_parties ppp
38: where ppp.RESOURCE_type_ID = 101
39: and ppp.project_id = p_project_id
40: and trunc(sysdate) between ppp.START_DATE_ACTIVE
41: and NVL(ppp.end_date_active, SYSDATE));

Line 102: from pa_project_parties ppp

98: FROM pa_employees
99: WHERE person_id = p_task_mgr_id
100: AND person_id in
101: ( select RESOURCE_source_ID
102: from pa_project_parties ppp
103: where ppp.RESOURCE_type_ID = 101
104: and ppp.project_id = p_project_id
105: and trunc(sysdate) between ppp.START_DATE_ACTIVE
106: and NVL(ppp.end_date_active, SYSDATE));