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

Line 567: FROM PA_PROJ_STRUCTURE_TYPES ppst,

563: -- checks whether the structure is a financial structure type
564: CURSOR l_check_financial_purpose_csr(c_structure_id NUMBER)
565: IS
566: SELECT 'Y'
567: FROM PA_PROJ_STRUCTURE_TYPES ppst,
568: PA_STRUCTURE_TYPES pst
569: WHERE ppst.proj_element_id = c_structure_id
570: AND ppst.structure_type_id = pst.structure_type_id
571: AND (pst.structure_type = 'FINANCIAL');

Line 577: FROM PA_PROJ_STRUCTURE_TYPES ppst,

573: -- checks whether the structure is a workplan structure type
574: CURSOR l_check_workplan_purpose_csr(c_structure_id NUMBER)
575: IS
576: SELECT 'Y'
577: FROM PA_PROJ_STRUCTURE_TYPES ppst,
578: PA_STRUCTURE_TYPES pst
579: WHERE ppst.proj_element_id = c_structure_id
580: AND ppst.structure_type_id = pst.structure_type_id
581: AND pst.structure_type = 'WORKPLAN';

Line 1468: pa_proj_structure_types ppst,

1464: where project_id = p_project_id
1465: and pm_source_reference = p_new_task_reference
1466: AND parent_structure_id = ( SELECT ppe.proj_element_id --Added this subQry for bug# 3601700
1467: FROM pa_proj_elements ppe,
1468: pa_proj_structure_types ppst,
1469: pa_structure_types pst
1470: WHERE ppe.proj_element_id = ppst.proj_element_id
1471: AND ppe.project_id = p_project_id
1472: AND ppst.structure_type_id = pst.structure_type_id