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_PROJ_STRUCTURE_TYPES

Line 293: pa_proj_structure_types ppst,

289: CURSOR cur_elem_ver_stru
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

Line 352: pa_proj_structure_types ppst,

348: ppevs.element_version_id,
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

Line 386: pa_proj_structure_types e

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
390: AND b.parent_structure_version_id = c.element_version_id

Line 408: pa_proj_structure_types ppst,

404: CURSOR cur_elem_ver_stru3
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'

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 441: pa_proj_structure_types ppst,

437: ppevs.element_version_id,
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;*/

Line 1121: ,pa_proj_structure_types ppst

1117: CURSOR cur_struc_type( x_structure_version_id NUMBER )
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

Line 3577: pa_proj_structure_types b

3573: IS
3574: SELECT c.element_version_id
3575: FROM pa_proj_element_versions c,
3576: pa_structure_types a,
3577: pa_proj_structure_types b
3578: ,pa_proj_elem_ver_structure d
3579: WHERE c.project_id = c_project_id
3580: AND a.structure_type_id = b.structure_type_id
3581: AND b.proj_element_id = c.proj_element_id

Line 3592: pa_proj_structure_types b,

3588: IS
3589: SELECT c.element_version_id
3590: FROM pa_proj_element_versions c,
3591: pa_structure_types a,
3592: pa_proj_structure_types b,
3593: pa_proj_elem_ver_structure d
3594: WHERE c.project_id = c_project_id
3595: AND a.structure_type_id = b.structure_type_id
3596: AND b.proj_element_id = c.proj_element_id

Line 4926: ,pa_proj_structure_types ppst

4922: FUNCTION check_fin_or_wp_structure( p_proj_element_id IN NUMBER ) RETURN VARCHAR2 IS
4923: CURSOR cur_chk_fin_or_wp_structure IS
4924: SELECT 'Y'
4925: FROM pa_proj_elements ppe
4926: ,pa_proj_structure_types ppst
4927: ,pa_structure_types pst
4928: WHERE ppe.proj_element_id = p_proj_element_id
4929: AND ppe.object_type = 'PA_STRUCTURES'
4930: AND ppe.proj_element_id = ppst.proj_element_id

Line 5224: FROM pa_proj_elements ppe, pa_proj_structure_types ppst

5220: CURSOR cur_pa_proj
5221: IS
5222:
5223: SELECT 'x'
5224: FROM pa_proj_elements ppe, pa_proj_structure_types ppst
5225: WHERE ppe.project_id = p_project_id
5226: AND ppe.object_type = 'PA_STRUCTURES'
5227: AND ppe.proj_element_id = ppst.proj_element_id
5228: AND ppst.structure_type_id = 1; --'WORKPLAN'

Line 5254: pa_proj_structure_types b,

5250: IS
5251: CURSOR c1 IS
5252: SELECT 'Y'
5253: FROM pa_proj_elements a,
5254: pa_proj_structure_types b,
5255: pa_structure_types c,
5256: pa_proj_structure_types d,
5257: pa_structure_types e
5258: WHERE c.structure_type_class_code = 'WORKPLAN'

Line 5256: pa_proj_structure_types d,

5252: SELECT 'Y'
5253: FROM pa_proj_elements a,
5254: pa_proj_structure_types b,
5255: pa_structure_types c,
5256: pa_proj_structure_types d,
5257: pa_structure_types e
5258: WHERE c.structure_type_class_code = 'WORKPLAN'
5259: AND e.structure_type_class_code = 'FINANCIAL'
5260: AND c.structure_type_id = b.structure_type_id