APPS.PA_XC_PROJECT_PUB dependencies on PA_STRUCTURE_TYPES

Line 579: PA_STRUCTURE_TYPES pst

575: CURSOR l_check_financial_purpose_csr(c_structure_id NUMBER)
576: IS
577: SELECT 'Y'
578: FROM PA_PROJ_STRUCTURE_TYPES ppst,
579: PA_STRUCTURE_TYPES pst
580: WHERE ppst.proj_element_id = c_structure_id
581: AND ppst.structure_type_id = pst.structure_type_id
582: AND (pst.structure_type = 'FINANCIAL');
583:

Line 589: PA_STRUCTURE_TYPES pst

585: CURSOR l_check_workplan_purpose_csr(c_structure_id NUMBER)
586: IS
587: SELECT 'Y'
588: FROM PA_PROJ_STRUCTURE_TYPES ppst,
589: PA_STRUCTURE_TYPES pst
590: WHERE ppst.proj_element_id = c_structure_id
591: AND ppst.structure_type_id = pst.structure_type_id
592: AND pst.structure_type = 'WORKPLAN';
593:

Line 1482: pa_structure_types pst

1478: and pm_source_reference = p_new_task_reference
1479: AND parent_structure_id = ( SELECT ppe.proj_element_id --Added this subQry for bug# 3601700
1480: FROM pa_proj_elements ppe,
1481: pa_proj_structure_types ppst,
1482: pa_structure_types pst
1483: WHERE ppe.proj_element_id = ppst.proj_element_id
1484: AND ppe.project_id = p_project_id
1485: AND ppst.structure_type_id = pst.structure_type_id
1486: AND pst.structure_type = 'WORKPLAN' --specified as workplan as this will only called while publishing workplan strcuture

Line 1506: PA_STRUCTURE_TYPES PST

1502: AND PM_SOURCE_REFERENCE = P_NEW_TASK_REFERENCE
1503: AND PARENT_STRUCTURE_ID = ( SELECT PPE.PROJ_ELEMENT_ID
1504: FROM PA_PROJ_ELEMENTS PPE,
1505: PA_PROJ_STRUCTURE_TYPES PPST,
1506: PA_STRUCTURE_TYPES PST
1507: WHERE PPE.PROJ_ELEMENT_ID = PPST.PROJ_ELEMENT_ID
1508: AND PPE.PROJECT_ID = P_PROJECT_ID
1509: AND PPST.STRUCTURE_TYPE_ID = PST.STRUCTURE_TYPE_ID
1510: AND PST.STRUCTURE_TYPE = 'WORKPLAN'