APPS.PA_FCST_GLOBAL dependencies on PA_PROJECTS_ALL

Line 334: FROM pa_projects_all pr1,

330: later in the code*/
331:
332: SELECT pr2.project_type_class_code
333: INTO l_project_type_class
334: FROM pa_projects_all pr1,
335: pa_project_types_all pr2
336: WHERE pr1.project_id = p_project_id
337: AND pr2.project_type = pr1.project_type
338: AND nvl(pr1.org_id,-99)=nvl(pr2.org_id,-99);

Line 716: pa_projects_all p2

712: max(p1.end_date)
713: INTO l_pl_start_date,
714: l_pl_end_date
715: FROM pa_fcst_periods_tmp_v p1,
716: pa_projects_all p2
717: WHERE p1.period_type = 'GL'
718: /* Commented the AND condition and modified for bug #3620818
719: AND p1.start_date between p2.start_date and
720: NVL(p2.completion_date, ll_end_date) */

Line 746: FROM pa_projects_all pr1,

742: pa_fcst_global.Global_pl_end_date := l_pl_end_date;
743:
744: SELECT pr2.project_type_class_code
745: INTO l_project_type_class
746: FROM pa_projects_all pr1,
747: pa_project_types_all pr2
748: WHERE pr1.project_id = p_project_id
749: AND pr2.project_type = pr1.project_type
750: AND nvl(pr1.org_id,-99)=nvl(pr2.org_id,-99);

Line 876: from pa_projects_all

872: x_return_status := FND_API.G_RET_STS_SUCCESS;
873:
874: select name, segment1
875: into x_project_name, x_project_number
876: from pa_projects_all
877: where project_id = p_project_id;
878:
879: select plan_run_date
880: into x_FI_Date