APPS.PA_PROGRESS_UTILS dependencies on PA_PROJECT_PARTIES

Line 122: from pa_project_parties

118: l_person_id := pa_utils.getempidfromuser(p_user_id);
119:
120: select 'Y'
121: into x_val
122: from pa_project_parties
123: where project_id = p_project_id
124: and resource_source_id = l_person_id
125: and project_role_id = 1
126: and trunc(sysdate) between trunc(start_date_active) and trunc(nvl(end_date_active,sysdate)); ----- Project Manager