APPS.PA_RESOURCE_PVT dependencies on PA_PROJECT_PARTIES
Line 1336: from pa_project_parties parties
1332: l_party_id NUMBER;
1333: BEGIN
1334: SELECT parties.resource_source_id
1335: INTO l_party_id 1336: from pa_project_parties parties 1337: where parties.project_role_id = 1
1338: AND parties.project_id = p_project_id
1339: AND trunc(sysdate) between parties.start_date_active AND NVL(parties.end_date_active,trunc(sysdate) + 1);
1340: