APPS.PA_TASK_TYPE_PVT dependencies on PA_PROJ_ELEMENTS

Line 607: FROM pa_proj_elements

603: SELECT 'X'
604: FROM dual
605: WHERE EXISTS
606: (SELECT proj_element_id
607: FROM pa_proj_elements
608: WHERE TYPE_ID=p_deliverable_type_id
609: AND OBJECT_TYPE='PA_DELIVERABLES'
610: AND 'Y' = (pa_deliverable_utils.IS_DELIVERABLE_HAS_PROGRESS(PROJECT_ID,PROJ_ELEMENT_ID)));
611:

Line 809: UPDATE PA_PROJ_ELEMENTS SET PROGRESS_WEIGHT = NULL

805: -- (i.e) If no progress records exist for any of the deliverables of this type,then
806: -- Null Out the Progress weight for all deliverables of this type
807:
808: IF l_allow_prog_entry_disable = 'Y' THEN
809: UPDATE PA_PROJ_ELEMENTS SET PROGRESS_WEIGHT = NULL
810: WHERE type_id = p_deliverable_type_id
811: AND OBJECT_TYPE = 'PA_DELIVERABLES'
812: AND PROGRESS_WEIGHT IS NOT NULL ;
813: END IF ;