DBA Data[Home] [Help]

APPS.PA_PROJ_STRUC_MAPPING_PUB dependencies on PA_PROJ_ELEMENTS

Line 466: , pa_proj_elements pae

462: ppv.element_version_id
463:
464: FROM
465: pa_proj_element_versions ppv
466: , pa_proj_elements pae
467: WHERE pae.name = l_task_name
468: AND pae.project_id = l_project_id
469: AND ppv.project_id = l_project_id
470: AND ppv.proj_element_id = pae.proj_element_id

Line 483: , pa_proj_elements pae

479: ppv.element_version_id
480:
481: FROM
482: pa_proj_element_versions ppv
483: , pa_proj_elements pae
484: , pa_proj_elem_ver_structure str_ver
485: , pa_proj_structure_types str_type
486: , pa_structure_types
487:

Line 881: FROM pa_proj_element_versions ppv, pa_proj_elements pae

877: -- This same cursor can be used for WP tasks
878: CURSOR c_get_wp_task_ver_id_frm_name (l_wp_task_name VARCHAR2 , l_projectid NUMBER ,l_prnt_str_ver_id NUMBER )
879: IS
880: SELECT ppv.element_version_id
881: FROM pa_proj_element_versions ppv, pa_proj_elements pae
882: WHERE pae.name = l_wp_task_name
883: AND pae.project_id = l_projectid
884: AND ppv.proj_element_id = pae.proj_element_id
885: AND ppv.parent_structure_version_id = l_prnt_str_ver_id

Line 906: , pa_proj_elements pae

902: SELECT
903: ppv.element_version_id
904: FROM
905: pa_proj_element_versions ppv
906: , pa_proj_elements pae
907: , pa_proj_elem_ver_structure str_ver
908: , pa_proj_structure_types str_type
909: , pa_structure_types
910: WHERE pae.name = l_task_name