APPS.PA_PROJECT_DATES_UTILS dependencies on PA_PROJECTS_ALL

Line 27: FROM PA_PROJECTS_ALL

23:
24: CURSOR get_dates_csr
25: IS
26: SELECT target_start_date, scheduled_start_date, actual_start_date, start_date -- Fix for Bug # 4506308.
27: FROM PA_PROJECTS_ALL
28: WHERE project_id = p_project_id;
29:
30: BEGIN
31:

Line 85: FROM PA_PROJECTS_ALL

81: CURSOR get_dates_csr
82: IS
83: SELECT target_finish_date, scheduled_finish_date, actual_finish_date, completion_date
84: -- Fix for Bug # 4506308.
85: FROM PA_PROJECTS_ALL
86: WHERE project_id = p_project_id;
87:
88: BEGIN
89:

Line 486: FROM PA_PROJECTS_ALL

482:
483: CURSOR get_dates_csr
484: IS
485: SELECT target_start_date, scheduled_start_date, actual_start_date
486: FROM PA_PROJECTS_ALL
487: WHERE project_id = p_project_id;
488:
489: BEGIN
490:

Line 538: FROM PA_PROJECTS_ALL

534:
535: CURSOR get_dates_csr
536: IS
537: SELECT target_start_date, scheduled_start_date, actual_start_date,start_date
538: FROM PA_PROJECTS_ALL
539: WHERE project_id = p_project_id;
540:
541: BEGIN
542:

Line 696: FROM PA_PROJECTS_ALL

692:
693: CURSOR get_dates_csr
694: IS
695: SELECT target_start_date, scheduled_start_date, actual_start_date
696: FROM PA_PROJECTS_ALL
697: WHERE project_id = p_project_id;
698:
699: BEGIN
700:

Line 739: FROM PA_PROJECTS_ALL

735:
736: CURSOR get_dates_csr
737: IS
738: SELECT target_finish_date, scheduled_finish_date, actual_finish_date
739: FROM PA_PROJECTS_ALL
740: WHERE project_id = p_project_id;
741:
742: BEGIN
743:

Line 1092: FROM pa_projects_all

1088:
1089: CURSOR l_prj_dt_minmax_csr (l_proj_id NUMBER)
1090: IS
1091: SELECT start_date, completion_date
1092: FROM pa_projects_all
1093: WHERE project_id = l_proj_id ;
1094:
1095: BEGIN
1096:

Line 1162: FROM pa_projects_all

1158:
1159: CURSOR l_prj_dt_minmax_csr (l_proj_id NUMBER)
1160: IS
1161: SELECT start_date, completion_date
1162: FROM pa_projects_all
1163: WHERE project_id = l_proj_id ;
1164:
1165:
1166: CURSOR l_templ_dt_minmax_csr (l_template_id NUMBER)