DBA Data[Home] [Help]

APPS.PA_WP_EXCEPTION_UTILS dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 494: pa_proj_elem_ver_structure str,

490: IS
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

Line 559: pa_proj_elem_ver_structure str,

555: IS
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

Line 624: pa_proj_elem_ver_structure str,

620: IS
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

Line 683: pa_proj_elem_ver_structure str,

679: IS
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