DBA Data[Home] [Help]

APPS.PA_RESOURCE_UTILS dependencies on PA_PROJECT_ASSIGNMENTS

Line 1817: FROM pa_project_assignments

1813: --Get the assignment start date
1814: BEGIN
1815: SELECT start_date
1816: INTO l_start_date
1817: FROM pa_project_assignments
1818: WHERE assignment_id = p_assignment_id
1819: ;
1820: EXCEPTION
1821: WHEN OTHERS THEN

Line 2388: pa_project_assignments asgmt,

2384: proj.project_id
2385: INTO l_proj_name_number,
2386: l_project_id
2387: FROM --pa_resources_denorm res,
2388: pa_project_assignments asgmt,
2389: pa_projects_all proj,
2390: pa_project_statuses ps
2391: WHERE --trunc(sysdate) between trunc(res.resource_effective_start_date)
2392: -- and trunc(res.resource_effective_end_date)

Line 4335: FROM pa_project_assignments

4331: --Get the assignment start date
4332: BEGIN
4333: SELECT start_date
4334: INTO l_start_date
4335: FROM pa_project_assignments
4336: WHERE assignment_id = p_assignment_id
4337: ;
4338: EXCEPTION
4339: WHEN OTHERS THEN