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_ELEMENTS_UTILS dependencies on PA_STRUCTURE_TYPES

Line 294: pa_structure_types pst

290: IS
291: SELECT element_version_id
292: FROM pa_proj_elem_ver_structure ppevs,
293: pa_proj_structure_types ppst,
294: pa_structure_types pst
295: WHERE ppevs.project_id = p_project_id
296: AND latest_eff_published_flag = 'Y'
297: AND ppst.proj_element_id = ppevs.proj_element_id
298: AND ppst.structure_type_id = pst.structure_type_id

Line 353: pa_structure_types pst

349: ppevs.name,
350: ppevs.record_version_number
351: FROM pa_proj_elem_ver_structure ppevs,
352: pa_proj_structure_types ppst,
353: pa_structure_types pst
354: WHERE ppevs.project_id = p_project_id
355: AND ppevs.status_code = 'STRUCTURE_WORKING'
356: AND ppst.proj_element_id = ppevs.proj_element_id
357: AND ppst.structure_type_id = pst.structure_type_id

Line 385: pa_structure_types d ,

381: c.record_version_number
382: FROM pa_proj_element_versions b,
383: pa_proj_elem_ver_schedule a,
384: pa_proj_elem_ver_structure c,
385: pa_structure_types d ,
386: pa_proj_structure_types e
387: WHERE a.element_version_id= b.element_version_id
388: AND a.project_id = b.project_id
389: AND a.proj_element_id = b.proj_element_id

Line 409: pa_structure_types pst

405: IS
406: SELECT ppe.proj_element_id
407: FROM pa_proj_elements ppe,
408: pa_proj_structure_types ppst,
409: pa_structure_types pst
410: WHERE ppe.project_id = p_project_id
411: AND ppe.object_type = 'PA_STRUCTURES'
412: -- AND ppe.status_code <> 'STRUCTURE_PUBLISHED'
413: AND ppst.proj_element_id = ppe.proj_element_id

Line 419: /* pa_proj_structure_types, pa_structure_types tables are not used in select list and where clause. */

415: AND pst.structure_type_class_code = 'WORKPLAN';
416: l_structure_id NUMBER;
417:
418: /* Bug No 3692971, For performance reasons the following tables are removed from the cursor query as */
419: /* pa_proj_structure_types, pa_structure_types tables are not used in select list and where clause. */
420: /* In case these two tables are required please add the following two join conditions to avoid full */
421: /* table scan on the structure_type tables */
422: /* AND ppst.proj_element_id = ppevs.proj_element_id */
423: /* AND ppst.structure_type_id = pst.structure_type_id */

Line 442: pa_structure_types pst

438: ppevs.name,
439: ppevs.record_version_number
440: FROM pa_proj_elem_ver_structure ppevs,
441: pa_proj_structure_types ppst,
442: pa_structure_types pst
443: WHERE ppevs.project_id = p_project_id
444: AND ppevs.proj_element_id = c_struc_id
445: AND ppevs.element_version_id = c_struc_ver_id;*/
446: BEGIN

Line 1122: ,pa_structure_types pst

1118: IS
1119: SELECT 'Y'
1120: FROM pa_proj_element_versions ppev
1121: ,pa_proj_structure_types ppst
1122: ,pa_structure_types pst
1123: WHERE ppev.element_version_id = x_structure_version_id
1124: AND ppev.proj_element_id = ppst.proj_element_id
1125: AND ppst.structure_type_id = pst.structure_type_id
1126: AND pst.structure_type_class_code = p_structure_type;

Line 3652: ,p_structure_type IN pa_structure_types.structure_type_class_code%TYPE

3648: ==================================================================*/
3649:
3650: PROCEDURE GET_STRUCTURE_INFO
3651: ( p_project_id IN pa_projects_all.project_id%TYPE
3652: ,p_structure_type IN pa_structure_types.structure_type_class_code%TYPE
3653: ,p_structure_id IN pa_proj_elements.proj_element_id%TYPE
3654: ,p_is_wp_separate_from_fn IN VARCHAR2
3655: ,p_is_wp_versioning_enabled IN VARCHAR2
3656: ,x_structure_version_id OUT NOCOPY pa_proj_element_versions.element_version_id%TYPE -- 4537865

Line 3669: pa_structure_types a,

3665: CURSOR cur_struc_ver_wp(c_project_id number,c_structure_type varchar2,c_status_code varchar2)
3666: IS
3667: SELECT c.element_version_id
3668: FROM pa_proj_element_versions c,
3669: pa_structure_types a,
3670: pa_proj_structure_types b
3671: ,pa_proj_elem_ver_structure d
3672: WHERE c.project_id = c_project_id
3673: AND a.structure_type_id = b.structure_type_id

Line 3684: pa_structure_types a,

3680: CURSOR cur_struc_ver_fin(c_project_id number,c_structure_type varchar2)
3681: IS
3682: SELECT c.element_version_id
3683: FROM pa_proj_element_versions c,
3684: pa_structure_types a,
3685: pa_proj_structure_types b,
3686: pa_proj_elem_ver_structure d
3687: WHERE c.project_id = c_project_id
3688: AND a.structure_type_id = b.structure_type_id

Line 5021: ,pa_structure_types pst

5017: CURSOR cur_chk_fin_or_wp_structure IS
5018: SELECT 'Y'
5019: FROM pa_proj_elements ppe
5020: ,pa_proj_structure_types ppst
5021: ,pa_structure_types pst
5022: WHERE ppe.proj_element_id = p_proj_element_id
5023: AND ppe.object_type = 'PA_STRUCTURES'
5024: AND ppe.proj_element_id = ppst.proj_element_id
5025: AND ppst.structure_type_id = pst.structure_type_id

Line 5349: pa_structure_types c,

5345: CURSOR c1 IS
5346: SELECT 'Y'
5347: FROM pa_proj_elements a,
5348: pa_proj_structure_types b,
5349: pa_structure_types c,
5350: pa_proj_structure_types d,
5351: pa_structure_types e
5352: WHERE c.structure_type_class_code = 'WORKPLAN'
5353: AND e.structure_type_class_code = 'FINANCIAL'

Line 5351: pa_structure_types e

5347: FROM pa_proj_elements a,
5348: pa_proj_structure_types b,
5349: pa_structure_types c,
5350: pa_proj_structure_types d,
5351: pa_structure_types e
5352: WHERE c.structure_type_class_code = 'WORKPLAN'
5353: AND e.structure_type_class_code = 'FINANCIAL'
5354: AND c.structure_type_id = b.structure_type_id
5355: AND e.structure_type_id = d.structure_type_id