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 382: , pa_proj_element_versions elemver

378:
379: CURSOR c_get_task_name IS
380: SELECT projelem.name
381: FROM pa_proj_elements projelem
382: , pa_proj_element_versions elemver
383: WHERE elemver.element_version_id = p_task_version_id
384: AND elemver.proj_element_id = projelem.proj_element_id
385: AND elemver.object_type = 'PA_TASKS'
386: AND projelem.object_type = 'PA_TASKS'

Line 461: from pa_proj_element_versions

457: elsif (p_structure_sharing_code = 'SHARE_PARTIAL') then
458: for l_c1rec in C1(p_element_version_id)
459: LOOP
460: select proj_element_id into l_proj_element_id
461: from pa_proj_element_versions
462: where element_version_id = l_c1rec.object_id_to1;
463: if (PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_proj_element_id) = 'Y') then
464: l_mapped_fin_task_version_id := l_c1rec.object_id_to1;
465: end if;

Line 488: from pa_proj_element_versions

484: l_mapped_fin_task_id NUMBER;
485: BEGIN
486: l_mapped_fin_task_version_id := GET_MAPPED_FIN_TASK_VERSION_ID(p_element_version_id,p_structure_sharing_code);
487: select proj_element_id into l_mapped_fin_task_id
488: from pa_proj_element_versions
489: where element_version_id = l_mapped_fin_task_version_id;
490: return (l_mapped_fin_task_id);
491: EXCEPTION
492: WHEN OTHERS THEN

Line 523: from pa_proj_element_versions

519: l_mapped_structure_version_id NUMBER;
520: BEGIN
521: l_mapped_fin_task_version_id := GET_MAPPED_FIN_TASK_VERSION_ID(p_element_version_id,p_structure_sharing_code);
522: select parent_structure_version_id into l_mapped_structure_version_id
523: from pa_proj_element_versions
524: where element_version_id = l_mapped_fin_task_version_id;
525: return (l_mapped_structure_version_id);
526: EXCEPTION
527: WHEN OTHERS THEN

Line 543: pa_proj_element_versions ppev,

539: CURSOR C_get_mapped_wkp_task_names IS
540: select ppe.name
541: from
542: pa_proj_elements ppe,
543: pa_proj_element_versions ppev,
544: pa_object_relationships por_mapping
545: where
546: ppe.proj_element_id=ppev.proj_element_id
547: and

Line 591: pa_proj_element_versions ppev,

587: CURSOR C_get_mapped_wkp_task_Ids IS
588: select ppe.proj_element_id
589: from
590: pa_proj_elements ppe,
591: pa_proj_element_versions ppev,
592: pa_object_relationships por_mapping
593: where
594: ppe.proj_element_id=ppev.proj_element_id
595: and

Line 638: pa_proj_element_versions ppev,

634: CURSOR C_get_mapped_fin_task_Id IS
635: select ppe.proj_element_id
636: from
637: pa_proj_elements ppe,
638: pa_proj_element_versions ppev,
639: pa_object_relationships por_mapping
640: where
641: ppe.proj_element_id=ppev.proj_element_id
642: and

Line 681: pa_proj_element_versions ppev,

677: CURSOR C_get_mapped_fin_task_name IS
678: select ppe.name
679: from
680: pa_proj_elements ppe,
681: pa_proj_element_versions ppev,
682: pa_object_relationships por_mapping
683: where
684: ppe.proj_element_id=ppev.proj_element_id
685: and