APPS.PA_PROJ_STRUCTURE_PVT dependencies on PA_PROJ_ELEMENTS

Line 112: FROM pa_proj_elements ppe,

108: --This cursor returns subproject association relationships ids for the
109: --given source task id and destination project id.
110: CURSOR get_src_task_det(cp_src_task_id NUMBER) IS
111: SELECT ppev.element_version_id src_task_ver_id,ppe.project_id src_proj_id
112: FROM pa_proj_elements ppe,
113: pa_proj_element_versions ppev,
114: pa_tasks pt
115: WHERE ppe.proj_element_id = cp_src_task_id
116: AND ppe.project_id = ppev.project_id

Line 168: PA_PROJ_ELEMENTS_UTILS.Project_Name_Or_Id(

164: PA_UTILS.ADD_Message('PA','PA_STRUCT_CREATE_ERR');
165: x_return_status := FND_API.G_RET_STS_ERROR;
166: END IF;
167: CLOSE get_src_task_det;
168: PA_PROJ_ELEMENTS_UTILS.Project_Name_Or_Id(
169: p_project_name => l_dest_proj_name
170: ,p_project_id => l_dest_proj_id
171: ,p_check_id_flag => PA_STARTUP.G_Check_ID_Flag
172: --,x_project_id => l_dest_proj_id * commented for Bug: 4537865

Line 381: FROM pa_proj_elements ppe,

377: --
378: --
379: CURSOR get_src_task_det(cp_src_task_id NUMBER) IS
380: SELECT ppev.element_version_id src_task_ver_id,ppe.project_id src_proj_id
381: FROM pa_proj_elements ppe,
382: pa_proj_element_versions ppev,
383: pa_tasks pt
384: WHERE ppe.proj_element_id = cp_src_task_id
385: AND ppe.project_id = ppev.project_id

Line 403: pa_proj_elements ppe

399: porb.record_version_number lnk_rel_rec_ver_number
400: FROM pa_proj_element_versions ppev,
401: pa_object_relationships pora,
402: pa_object_relationships porb,
403: pa_proj_elements ppe
404: WHERE pora.relationship_type = 'S'
405: AND ppev.project_id = cp_src_proj_id
406: AND pora.OBJECT_ID_FROM1 = cp_src_task_ver_id
407: AND pora.object_type_from = 'PA_TASKS'

Line 427: pa_proj_elements ppe

423: porb.record_version_number lnk_rel_rec_ver_number
424: FROM pa_proj_element_versions ppev,
425: pa_object_relationships pora,
426: pa_object_relationships porb,
427: pa_proj_elements ppe
428: WHERE pora.relationship_type = 'S'
429: AND ppev.project_id = cp_src_proj_id
430: AND pora.OBJECT_ID_FROM1 = cp_src_task_ver_id
431: AND pora.object_type_from = 'PA_TASKS'