APPS.PA_PROJECT_STUS_UTILS dependencies on PA_PROJ_ELEMENTS
Line 906: Where exists(Select 'XYZ' from pa_proj_elements
902: -- checking whether the phase to be deleted has been used by a lifecycle
903: Select 'PA_PHASE_LIFECYCLE_USED','N'
904: Into x_err_stage,x_allow_deletion_flag
905: From dual 906: Where exists(Select 'XYZ' from pa_proj_elements 907: where project_id= 0 and object_type = 'PA_TASKS'
908: and phase_code= p_project_status_code);
909: -- check for PLM needs to be added
910: -- 4537865