APPS.PA_WP_EXCEPTION_UTILS dependencies on PA_STRUCTURE_TYPES

Line 496: pa_structure_types pst

492: select sch.scheduled_finish_date
493: from pa_proj_elem_ver_schedule sch,
494: pa_proj_elem_ver_structure str,
495: pa_proj_structure_types ppst,
496: pa_structure_types pst
497: where pst.structure_type = 'WORKPLAN'
498: and pst.structure_type_id = ppst.structure_type_id
499: and ppst.proj_element_id = str.proj_element_id
500: and str.project_id = p_object_id

Line 561: pa_structure_types pst

557: select sch.scheduled_start_date
558: from pa_proj_elem_ver_schedule sch,
559: pa_proj_elem_ver_structure str,
560: pa_proj_structure_types ppst,
561: pa_structure_types pst
562: where pst.structure_type = 'WORKPLAN'
563: and pst.structure_type_id = ppst.structure_type_id
564: and ppst.proj_element_id = str.proj_element_id
565: and str.project_id = p_object_id

Line 626: pa_structure_types pst

622: select sch.scheduled_finish_date, nvl(sch.estimated_finish_date, sch.scheduled_finish_date)
623: from pa_proj_elem_ver_schedule sch,
624: pa_proj_elem_ver_structure str,
625: pa_proj_structure_types ppst,
626: pa_structure_types pst
627: where pst.structure_type = 'WORKPLAN'
628: and pst.structure_type_id = ppst.structure_type_id
629: and ppst.proj_element_id = str.proj_element_id
630: and str.project_id = p_object_id

Line 685: pa_structure_types pst

681: select sch.scheduled_start_date, nvl(sch.estimated_start_date, sch.scheduled_start_date)
682: from pa_proj_elem_ver_schedule sch,
683: pa_proj_elem_ver_structure str,
684: pa_proj_structure_types ppst,
685: pa_structure_types pst
686: where pst.structure_type = 'WORKPLAN'
687: and pst.structure_type_id = ppst.structure_type_id
688: and ppst.proj_element_id = str.proj_element_id
689: and str.project_id = p_object_id