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 3670: pa_proj_structure_types b

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
3674: AND b.proj_element_id = c.proj_element_id

Line 3685: pa_proj_structure_types b,

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
3689: AND b.proj_element_id = c.proj_element_id

Line 5020: ,pa_proj_structure_types ppst

5016: FUNCTION check_fin_or_wp_structure( p_proj_element_id IN NUMBER ) RETURN VARCHAR2 IS
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

Line 5318: FROM pa_proj_elements ppe, pa_proj_structure_types ppst

5314: CURSOR cur_pa_proj
5315: IS
5316:
5317: SELECT 'x'
5318: FROM pa_proj_elements ppe, pa_proj_structure_types ppst
5319: WHERE ppe.project_id = p_project_id
5320: AND ppe.object_type = 'PA_STRUCTURES'
5321: AND ppe.proj_element_id = ppst.proj_element_id
5322: AND ppst.structure_type_id = 1; --'WORKPLAN'

Line 5348: pa_proj_structure_types b,

5344: IS
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'

Line 5350: pa_proj_structure_types d,

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'
5354: AND c.structure_type_id = b.structure_type_id