APPS.PA_RESOURCE_PVT dependencies on PA_PROJECT_PARTIES

Line 1430: from pa_project_parties parties

1426: l_party_id NUMBER;
1427: BEGIN
1428: SELECT parties.resource_source_id
1429: INTO l_party_id
1430: from pa_project_parties parties
1431: where parties.project_role_id = 1
1432: AND parties.project_id = p_project_id
1433: AND trunc(sysdate) between parties.start_date_active AND NVL(parties.end_date_active,trunc(sysdate) + 1)--;
1434: -- start -- 18-AUG-2008 cklee Fixed bug: 6708404