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_PROJECT_PUB dependencies on PA_PROJ_STRUCTURE_TYPES

Line 5661: ,pa_proj_structure_types ppst

5657: --Added for bug 3746912
5658: CURSOR cur_get_str_type_from_str_id( c_structure_version_id IN NUMBER ) IS
5659: SELECT pst.structure_type
5660: FROM pa_proj_element_versions ppev
5661: ,pa_proj_structure_types ppst
5662: ,pa_structure_types pst
5663: WHERE ppev.element_version_id = c_structure_version_id
5664: AND ppev.proj_element_id = ppst.proj_element_id
5665: AND ppst.structure_type_id = pst.structure_type_id ;

Line 9847: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b

9843: --Cursor to get the current published version when structure type and project id is known
9844: CURSOR cur_struc_ver_fin(c_project_id pa_projects_all.project_id%TYPE, c_structure_type pa_structure_types.structure_type%TYPE)
9845: IS
9846: SELECT c.element_version_id
9847: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
9848: ,pa_proj_elem_ver_structure d
9849: WHERE c.project_id = c_project_id
9850: AND a.structure_type_id = b.structure_type_id
9851: AND b.proj_element_id = c.proj_element_id

Line 9862: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b

9858: --Cursor to get the working version when structure type and project id is known
9859: CURSOR cur_struc_ver_wp(c_project_id pa_projects_all.project_id%TYPE, c_structure_type pa_structure_types.structure_type%TYPE)
9860: IS
9861: SELECT c.element_version_id
9862: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
9863: ,pa_proj_elem_ver_structure d
9864: WHERE c.project_id = c_project_id
9865: AND a.structure_type_id = b.structure_type_id
9866: AND b.proj_element_id = c.proj_element_id

Line 22429: , pa_proj_structure_types b

22425: IS
22426: SELECT c.element_version_id
22427: FROM pa_proj_element_versions c
22428: , pa_structure_types a
22429: , pa_proj_structure_types b
22430: , pa_proj_elem_ver_structure d
22431: WHERE c.project_id = l_project_id
22432: AND a.structure_type_id = b.structure_type_id
22433: AND b.proj_element_id = c.proj_element_id

Line 22445: , pa_proj_structure_types b

22441: IS
22442: SELECT c.element_version_id
22443: FROM pa_proj_element_versions c
22444: , pa_structure_types a
22445: , pa_proj_structure_types b
22446: , pa_proj_elem_ver_structure d
22447: WHERE c.project_id = l_project_id
22448: AND a.structure_type_id = b.structure_type_id
22449: AND b.proj_element_id = c.proj_element_id

Line 36384: , pa_proj_structure_types ppst, pa_structure_types pst

36380:
36381: cursor l_cur_task_ver_id(c_task_id NUMBER, c_structure_type VARCHAR2) is
36382: select ppev.element_version_id
36383: from pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs
36384: , pa_proj_structure_types ppst, pa_structure_types pst
36385: where ppevs.proj_element_id = ppst.proj_element_id
36386: and ppst.structure_type_id = pst.structure_type_id
36387: and ppev.project_id = ppevs.project_id
36388: and ppev.parent_structure_version_id = ppevs.element_version_id

Line 36965: , pa_proj_structure_types ppst, pa_structure_types pst

36961:
36962: cursor l_cur_task_ver_id(c_task_id NUMBER, c_structure_type VARCHAR2) is
36963: select ppev.element_version_id
36964: from pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs
36965: , pa_proj_structure_types ppst, pa_structure_types pst
36966: where ppevs.proj_element_id = ppst.proj_element_id
36967: and ppst.structure_type_id = pst.structure_type_id
36968: and ppev.project_id = ppevs.project_id
36969: and ppev.parent_structure_version_id = ppevs.element_version_id

Line 37553: , pa_proj_structure_types ppst, pa_structure_types pst

37549:
37550: cursor l_cur_task_ver_id(c_task_id NUMBER, c_structure_type VARCHAR2) is
37551: select ppev.element_version_id
37552: from pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs
37553: , pa_proj_structure_types ppst, pa_structure_types pst
37554: where ppevs.proj_element_id = ppst.proj_element_id
37555: and ppst.structure_type_id = pst.structure_type_id
37556: and ppev.project_id = ppevs.project_id
37557: and ppev.parent_structure_version_id = ppevs.element_version_id

Line 37970: pa_proj_structure_types ppst

37966: cursor c_prev_published_version(p_pa_project_id IN NUMBER) is
37967: select element_version_id from (
37968: select element_version_id
37969: from pa_proj_elem_ver_structure ppevs,
37970: pa_proj_structure_types ppst
37971: where ppevs.latest_eff_published_flag = 'N'
37972: and ppst.proj_element_id = ppevs.proj_element_id
37973: and ppst.structure_type_id = 1
37974: and ppevs.status_code = 'STRUCTURE_PUBLISHED'