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

Line 10195: pa_proj_structure_types ppst,

10191: , a.prg_level
10192: , ppr.as_of_date
10193: FROM pa_proj_element_versions a,
10194: pa_proj_elem_ver_structure b,
10195: pa_proj_structure_types ppst,
10196: pa_proj_element_versions c,
10197: pa_progress_rollup ppr
10198: WHERE
10199: c.project_id = p_project_id

Line 10343: from pa_proj_elem_ver_structure ppevs, pa_proj_structure_types ppst

10339: x_msg_data OUT NOCOPY VARCHAR2) IS
10340:
10341: cursor new_str_version_id is
10342: select ppevs.element_version_id
10343: from pa_proj_elem_ver_structure ppevs, pa_proj_structure_types ppst
10344: where ppevs.project_id = p_project_id
10345: and ppevs.proj_element_id = ppst.proj_element_id
10346: and ppst.structure_type_id = 1
10347: and ppevs.STATUS_CODE = 'STRUCTURE_PUBLISHED'

Line 10350: pa_proj_structure_types ppst

10346: and ppst.structure_type_id = 1
10347: and ppevs.STATUS_CODE = 'STRUCTURE_PUBLISHED'
10348: and ppevs.PUBLISHED_DATE = (select min(ppevs.published_date)
10349: from pa_proj_elem_ver_structure ppevs,
10350: pa_proj_structure_types ppst
10351: where ppevs.project_id = p_project_id
10352: and ppevs.proj_element_id = ppst.proj_element_id
10353: and ppst.structure_type_id = 1
10354: and ppevs.STATUS_CODE = 'STRUCTURE_PUBLISHED'