APPS.PA_WP_EXCEPTION_UTILS dependencies on PA_PROJ_STRUCTURE_TYPES

Line 495: pa_proj_structure_types ppst,

491: CURSOR c1 IS
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

Line 560: pa_proj_structure_types ppst,

556: CURSOR c1 IS
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

Line 625: pa_proj_structure_types ppst,

621: CURSOR c1 IS
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

Line 684: pa_proj_structure_types ppst,

680: CURSOR c1 IS
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