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.

[Home] [Help]

APPS.PA_PROJECT_PVT dependencies on PA_PROJ_STRUCTURE_TYPES

Line 4073: pa_proj_structure_types ppst,

4069: WHERE PM_SOURCE_REFERENCE = p_pm_task_reference
4070: AND project_id = p_pa_project_id
4071: AND parent_structure_id = ( SELECT ppe.proj_element_id --Added this subQry for bug#3653517
4072: FROM pa_proj_elements ppe,
4073: pa_proj_structure_types ppst,
4074: pa_structure_types pst
4075: WHERE ppe.proj_element_id = ppst.proj_element_id
4076: AND ppe.project_id = p_pa_project_id
4077: AND ppst.structure_type_id = pst.structure_type_id

Line 11019: FROM pa_proj_elements ppe, pa_proj_structure_types ppst

11015: IS
11016: CURSOR cur_proj_elems
11017: IS
11018: SELECT ppe.proj_element_id
11019: FROM pa_proj_elements ppe, pa_proj_structure_types ppst
11020: WHERE ppe.proj_element_id = ppst.proj_element_id
11021: AND ppe.project_id = p_project_id
11022: AND ppe.object_type = 'PA_STRUCTURES'
11023: AND ppst.structure_type_id = 1 ;

Line 11027: FROM pa_proj_structure_types b

11023: AND ppst.structure_type_id = 1 ;
11024:
11025: CURSOR c1( c_proj_element_id NUMBER ) is
11026: SELECT d.element_version_id
11027: FROM pa_proj_structure_types b
11028: ,pa_proj_elem_ver_structure d
11029: WHERE d.project_id = p_project_id
11030: AND 1 = b.structure_type_id
11031: AND b.proj_element_id = c_proj_element_id