APPS.PA_PROJ_STRUC_MAPPING_UTILS dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 40: FROM PA_PROJ_ELEMENT_VERSIONS elver

36: -- This cursor fetches the element version Ids for the passed element id, of the type PA_TASKS
37: CURSOR c_get_element_version_id
38: IS
39: SELECT element_version_id
40: FROM PA_PROJ_ELEMENT_VERSIONS elver
41: WHERE elver.proj_element_id = p_proj_element_id
42: AND elver.object_type='PA_TASKS'
43: AND elver.project_id = p_project_id;
44:

Line 391: , pa_proj_element_versions elemver

387:
388: CURSOR c_get_task_name IS
389: SELECT projelem.name
390: FROM pa_proj_elements projelem
391: , pa_proj_element_versions elemver
392: WHERE elemver.element_version_id = p_task_version_id
393: AND elemver.proj_element_id = projelem.proj_element_id
394: AND elemver.object_type = 'PA_TASKS'
395: AND projelem.object_type = 'PA_TASKS'

Line 470: from pa_proj_element_versions

466: elsif (p_structure_sharing_code = 'SHARE_PARTIAL') then
467: for l_c1rec in C1(p_element_version_id)
468: LOOP
469: select proj_element_id into l_proj_element_id
470: from pa_proj_element_versions
471: where element_version_id = l_c1rec.object_id_to1;
472: if (PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_proj_element_id) = 'Y') then
473: l_mapped_fin_task_version_id := l_c1rec.object_id_to1;
474: end if;

Line 497: from pa_proj_element_versions

493: l_mapped_fin_task_id NUMBER;
494: BEGIN
495: l_mapped_fin_task_version_id := GET_MAPPED_FIN_TASK_VERSION_ID(p_element_version_id,p_structure_sharing_code);
496: select proj_element_id into l_mapped_fin_task_id
497: from pa_proj_element_versions
498: where element_version_id = l_mapped_fin_task_version_id;
499: return (l_mapped_fin_task_id);
500: EXCEPTION
501: WHEN OTHERS THEN

Line 532: from pa_proj_element_versions

528: l_mapped_structure_version_id NUMBER;
529: BEGIN
530: l_mapped_fin_task_version_id := GET_MAPPED_FIN_TASK_VERSION_ID(p_element_version_id,p_structure_sharing_code);
531: select parent_structure_version_id into l_mapped_structure_version_id
532: from pa_proj_element_versions
533: where element_version_id = l_mapped_fin_task_version_id;
534: return (l_mapped_structure_version_id);
535: EXCEPTION
536: WHEN OTHERS THEN

Line 552: pa_proj_element_versions ppev,

548: CURSOR C_get_mapped_wkp_task_names IS
549: select ppe.name
550: from
551: pa_proj_elements ppe,
552: pa_proj_element_versions ppev,
553: pa_object_relationships por_mapping
554: where
555: ppe.proj_element_id=ppev.proj_element_id
556: and

Line 600: pa_proj_element_versions ppev,

596: CURSOR C_get_mapped_wkp_task_Ids IS
597: select ppe.proj_element_id
598: from
599: pa_proj_elements ppe,
600: pa_proj_element_versions ppev,
601: pa_object_relationships por_mapping
602: where
603: ppe.proj_element_id=ppev.proj_element_id
604: and

Line 647: pa_proj_element_versions ppev,

643: CURSOR C_get_mapped_fin_task_Id IS
644: select ppe.proj_element_id
645: from
646: pa_proj_elements ppe,
647: pa_proj_element_versions ppev,
648: pa_object_relationships por_mapping
649: where
650: ppe.proj_element_id=ppev.proj_element_id
651: and

Line 690: pa_proj_element_versions ppev,

686: CURSOR C_get_mapped_fin_task_name IS
687: select ppe.name
688: from
689: pa_proj_elements ppe,
690: pa_proj_element_versions ppev,
691: pa_object_relationships por_mapping
692: where
693: ppe.proj_element_id=ppev.proj_element_id
694: and