112:
113: CURSOR get_proj_sch_dates_csr
114: IS
115: SELECT scheduled_start_date, scheduled_finish_date
116: FROM PA_PROJECTS_ALL
117: WHERE project_id = p_project_id;
118:
119: CURSOR get_proj_act_dates_csr
120: IS
118:
119: CURSOR get_proj_act_dates_csr
120: IS
121: SELECT actual_start_date, actual_finish_date
122: FROM PA_PROJECTS_ALL
123: WHERE project_id = p_project_id;
124:
125: /*
126: CURSOR get_proj_est_dates_csr
125: /*
126: CURSOR get_proj_est_dates_csr
127: IS
128: SELECT estimated_start_date, estimated_finish_date
129: FROM PA_PROJECTS_ALL
130: WHERE project_id = p_project_id;
131: */
132:
133: CURSOR get_proj_bas_dates_csr
132:
133: CURSOR get_proj_bas_dates_csr
134: IS
135: SELECT baseline_start_date, baseline_finish_date
136: FROM PA_PROJECTS_ALL
137: WHERE project_id = p_project_id;
138:
139: CURSOR get_proj_record_ver_number
140: IS
138:
139: CURSOR get_proj_record_ver_number
140: IS
141: SELECT record_version_number
142: FROM PA_PROJECTS_ALL
143: WHERE project_id = p_project_id;
144:
145: CURSOR get_task_record_ver_number(c_task_id NUMBER)
146: IS