DBA Data[Home] [Help]

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: