DBA Data[Home] [Help]

APPS.PA_PROJECT_DATES_PUB dependencies on PA_PROJECTS_ALL

Line 116: FROM PA_PROJECTS_ALL

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

Line 122: FROM PA_PROJECTS_ALL

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

Line 129: FROM PA_PROJECTS_ALL

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

Line 136: FROM PA_PROJECTS_ALL

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

Line 142: FROM PA_PROJECTS_ALL

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