APPS.PA_PROJECT_DATES_UTILS dependencies on PA_PROJECTS_ALL

Line 33: FROM PA_PROJECTS_ALL

29:
30: CURSOR get_dates_csr
31: IS
32: SELECT target_start_date, scheduled_start_date, actual_start_date, start_date -- Fix for Bug # 4506308.
33: FROM PA_PROJECTS_ALL
34: WHERE project_id = p_project_id;
35:
36: -- Begin fix for Bug # 12940745.
37: CURSOR c_auto_flag_enabled

Line 51: from PA_PROJECTS_ALL

47:
48: CURSOR c_struct_code
49: IS
50: select STRUCTURE_SHARING_CODE
51: from PA_PROJECTS_ALL
52: where project_id = p_project_id;
53: -- End fix for Bug # 12940745.
54: BEGIN
55:

Line 125: FROM PA_PROJECTS_ALL

121: CURSOR get_dates_csr
122: IS
123: SELECT target_finish_date, scheduled_finish_date, actual_finish_date, completion_date
124: -- Fix for Bug # 4506308.
125: FROM PA_PROJECTS_ALL
126: WHERE project_id = p_project_id;
127:
128: BEGIN
129:

Line 526: FROM PA_PROJECTS_ALL

522:
523: CURSOR get_dates_csr
524: IS
525: SELECT target_start_date, scheduled_start_date, actual_start_date
526: FROM PA_PROJECTS_ALL
527: WHERE project_id = p_project_id;
528:
529: BEGIN
530:

Line 578: FROM PA_PROJECTS_ALL

574:
575: CURSOR get_dates_csr
576: IS
577: SELECT target_start_date, scheduled_start_date, actual_start_date,start_date
578: FROM PA_PROJECTS_ALL
579: WHERE project_id = p_project_id;
580:
581: BEGIN
582:

Line 736: FROM PA_PROJECTS_ALL

732:
733: CURSOR get_dates_csr
734: IS
735: SELECT target_start_date, scheduled_start_date, actual_start_date
736: FROM PA_PROJECTS_ALL
737: WHERE project_id = p_project_id;
738:
739: BEGIN
740:

Line 779: FROM PA_PROJECTS_ALL

775:
776: CURSOR get_dates_csr
777: IS
778: SELECT target_finish_date, scheduled_finish_date, actual_finish_date
779: FROM PA_PROJECTS_ALL
780: WHERE project_id = p_project_id;
781:
782: BEGIN
783:

Line 1132: FROM pa_projects_all

1128:
1129: CURSOR l_prj_dt_minmax_csr (l_proj_id NUMBER)
1130: IS
1131: SELECT start_date, completion_date
1132: FROM pa_projects_all
1133: WHERE project_id = l_proj_id ;
1134:
1135: BEGIN
1136:

Line 1195: FROM pa_projects_all

1191:
1192: CURSOR l_prj_dt_minmax_csr (l_proj_id NUMBER)
1193: IS
1194: SELECT start_date, completion_date
1195: FROM pa_projects_all
1196: WHERE project_id = l_proj_id ;
1197:
1198: l_validate VARCHAR2 (2000);
1199: l_validate_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;

Line 1349: FROM pa_projects_all

1345:
1346: CURSOR l_prj_dt_minmax_csr (l_proj_id NUMBER)
1347: IS
1348: SELECT start_date, completion_date
1349: FROM pa_projects_all
1350: WHERE project_id = l_proj_id ;
1351:
1352: l_validate varchar2(2000);
1353: l_validate_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := x_validate_tbl;

Line 1504: FROM pa_projects_all

1500:
1501: CURSOR l_prj_dt_minmax_csr (l_proj_id NUMBER)
1502: IS
1503: SELECT start_date, completion_date
1504: FROM pa_projects_all
1505: WHERE project_id = l_proj_id ;
1506:
1507:
1508: CURSOR l_templ_dt_minmax_csr (l_template_id NUMBER)