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_ELEMENT_VERSIONS

Line 465: pa_proj_element_versions ppv

461: SELECT
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

Line 482: pa_proj_element_versions ppv

478: SELECT
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

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 905: pa_proj_element_versions ppv

901: IS
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

Line 1314: pa_proj_element_versions pelever,

1310: pelever.element_version_id AS structure_version
1311: , pelever.attribute15 AS src_str_version_id
1312: , pstrType.structure_type AS structure_type
1313: FROM
1314: pa_proj_element_versions pelever,
1315: pa_proj_structure_types prjstrType,
1316: pa_structure_types pstrType
1317: WHERE
1318: pelever.object_type = 'PA_STRUCTURES'

Line 1338: pa_proj_element_versions elever

1334: SELECT
1335: paObrel.OBJECT_ID_FROM1 as OBJECT_ID_FROM1
1336: , paObrel.OBJECT_ID_TO1 as OBJECT_ID_TO1
1337: FROM
1338: pa_proj_element_versions elever
1339: , pa_object_relationships paObrel
1340: WHERE elever.PARENT_STRUCTURE_VERSION_ID = l_parent_str_version_id
1341: AND paObrel.OBJECT_ID_FROM1 = elever.element_version_id
1342: AND elever.project_id = l_project_id

Line 1346: -- This cursor will get the task version id from pa_proj_element_versions , where src task version id is passed

1342: AND elever.project_id = l_project_id
1343: AND paObrel.RELATIONSHIP_TYPE = 'M'
1344: AND elever.object_type = 'PA_TASKS';
1345:
1346: -- This cursor will get the task version id from pa_proj_element_versions , where src task version id is passed
1347: CURSOR c_get_mapped_task_version ( l_src_task_version_id NUMBER, l_project_id NUMBER )
1348: IS
1349: SELECT ELEMENT_VERSION_ID
1350: FROM PA_PROJ_ELEMENT_VERSIONS ELEVER

Line 1350: FROM PA_PROJ_ELEMENT_VERSIONS ELEVER

1346: -- This cursor will get the task version id from pa_proj_element_versions , where src task version id is passed
1347: CURSOR c_get_mapped_task_version ( l_src_task_version_id NUMBER, l_project_id NUMBER )
1348: IS
1349: SELECT ELEMENT_VERSION_ID
1350: FROM PA_PROJ_ELEMENT_VERSIONS ELEVER
1351: WHERE ELEVER.ATTRIBUTE15 = l_src_task_version_id
1352: AND ELEVER.OBJECT_TYPE = 'PA_TASKS'
1353: AND ELEVER.PROJECT_ID = l_project_id;
1354:

Line 1358: FROM pa_proj_element_versions

1354:
1355: CURSOR c_get_mapped_task_id ( l_task_ver_id NUMBER , l_str_version_id NUMBER, l_project_id NUMBER )
1356: IS
1357: SELECT proj_element_id
1358: FROM pa_proj_element_versions
1359: WHERE OBJECT_TYPE = 'PA_TASKS'
1360: AND element_version_id = l_task_ver_id
1361: AND parent_structure_version_id = l_str_version_id
1362: AND pa_proj_element_versions.project_id = l_project_id;

Line 1362: AND pa_proj_element_versions.project_id = l_project_id;

1358: FROM pa_proj_element_versions
1359: WHERE OBJECT_TYPE = 'PA_TASKS'
1360: AND element_version_id = l_task_ver_id
1361: AND parent_structure_version_id = l_str_version_id
1362: AND pa_proj_element_versions.project_id = l_project_id;
1363:
1364: CURSOR c_get_mapped_task_ver_id ( l_task_id NUMBER , l_str_version_id NUMBER, l_project_id NUMBER )
1365: IS
1366: SELECT element_version_id

Line 1367: FROM pa_proj_element_versions

1363:
1364: CURSOR c_get_mapped_task_ver_id ( l_task_id NUMBER , l_str_version_id NUMBER, l_project_id NUMBER )
1365: IS
1366: SELECT element_version_id
1367: FROM pa_proj_element_versions
1368: WHERE OBJECT_TYPE = 'PA_TASKS'
1369: AND parent_structure_version_id = l_str_version_id
1370: AND proj_element_id = l_task_id
1371: AND pa_proj_element_versions.project_id = l_project_id;

Line 1371: AND pa_proj_element_versions.project_id = l_project_id;

1367: FROM pa_proj_element_versions
1368: WHERE OBJECT_TYPE = 'PA_TASKS'
1369: AND parent_structure_version_id = l_str_version_id
1370: AND proj_element_id = l_task_id
1371: AND pa_proj_element_versions.project_id = l_project_id;
1372:
1373: l_src_from_tasks_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
1374: l_src_to_tasks_id_tbl PA_PROJ_STRUC_MAPPING_PUB.OBJECT_VERSION_ID_TABLE_TYPE;
1375:

Line 1779: pa_proj_element_versions elever1

1775: IS
1776: SELECT
1777: obRel.object_relationship_id
1778: FROM
1779: pa_proj_element_versions elever1
1780: , pa_proj_element_versions elever2
1781: -- , pa_proj_structure_types projStrType Bug 3693235 Performance Fix
1782: -- , pa_structure_types strType Bug 3693235 Performance Fix
1783: , pa_object_relationships obRel

Line 1780: , pa_proj_element_versions elever2

1776: SELECT
1777: obRel.object_relationship_id
1778: FROM
1779: pa_proj_element_versions elever1
1780: , pa_proj_element_versions elever2
1781: -- , pa_proj_structure_types projStrType Bug 3693235 Performance Fix
1782: -- , pa_structure_types strType Bug 3693235 Performance Fix
1783: , pa_object_relationships obRel
1784: WHERE