eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJ_STRUC_MAPPING_PUB dependencies on PA_PROJ_ELEMENTS

Line 472: , pa_proj_elements pae

468: ppv.element_version_id
469:
470: FROM
471: pa_proj_element_versions ppv
472: , pa_proj_elements pae
473: WHERE pae.name = l_task_name
474: AND pae.project_id = l_project_id
475: AND ppv.project_id = l_project_id
476: AND ppv.proj_element_id = pae.proj_element_id

Line 489: , pa_proj_elements pae

485: ppv.element_version_id
486:
487: FROM
488: pa_proj_element_versions ppv
489: , pa_proj_elements pae
490: , pa_proj_elem_ver_structure str_ver
491: , pa_proj_structure_types str_type
492: , pa_structure_types
493:

Line 912: FROM pa_proj_element_versions ppv, pa_proj_elements pae

908: -- This same cursor can be used for WP tasks
909: CURSOR c_get_wp_task_ver_id_frm_name (l_wp_task_name VARCHAR2 , l_projectid NUMBER ,l_prnt_str_ver_id NUMBER )
910: IS
911: SELECT ppv.element_version_id
912: FROM pa_proj_element_versions ppv, pa_proj_elements pae
913: WHERE pae.name = l_wp_task_name
914: AND pae.project_id = l_projectid
915: AND ppv.proj_element_id = pae.proj_element_id
916: AND ppv.parent_structure_version_id = l_prnt_str_ver_id

Line 937: , pa_proj_elements pae

933: SELECT
934: ppv.element_version_id
935: FROM
936: pa_proj_element_versions ppv
937: , pa_proj_elements pae
938: , pa_proj_elem_ver_structure str_ver
939: , pa_proj_structure_types str_type
940: , pa_structure_types
941: WHERE pae.name = l_task_name