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_STRUCTURE_TYPES

Line 568: PA_STRUCTURE_TYPES pst

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');
572:

Line 578: PA_STRUCTURE_TYPES pst

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';
582:

Line 1469: pa_structure_types pst

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
1473: AND pst.structure_type = 'WORKPLAN' --specified as workplan as this will only called while publishing workplan strcuture