DBA Data[Home] [Help]

APPS.PA_PROJECT_DATES_UTILS dependencies on PA_PROJECTS_PRM_V

Line 1276: FROM pa_projects_prm_v proj

1272:
1273: IF l_validate_tbl(i) = 'Y' THEN
1274: SELECT start_date, completion_date
1275: INTO l_start_date, l_completion_date
1276: FROM pa_projects_prm_v proj
1277: WHERE project_id = p_project_id_tbl(i);
1278:
1279: IF (l_start_date_status_tbl(i) = 'I' AND l_start_date IS NOT NULL ) THEN
1280: l_msg_data_tbl(i) := 'PA_PJR_DATE_START_ERROR';

Line 1414: from pa_projects_prm_v proj

1410:
1411:
1412: select start_date, completion_date
1413: into l_start_date, l_completion_date
1414: from pa_projects_prm_v proj
1415: where project_id = p_project_id_tbl(i);
1416:
1417: if (l_start_date_status_tbl(i) = 'I' and l_start_date is not null) then
1418: l_msg_data_tbl(i) := 'PA_PJR_DATE_START_ERROR';