DBA Data[Home] [Help]

APPS.PA_TASKS_MAINT_UTILS dependencies on PA_PROJ_ELEM_VER_SCHEDULE

Line 486: select scheduled_start_date,scheduled_finish_date from pa_proj_elem_ver_schedule where

482: connect by prior task_id= parent_task_id; --Bug 6163119
483:
484: --bug 8566495 anuragag
485: cursor get_parent_dates(p_task_id NUMBER) is
486: select scheduled_start_date,scheduled_finish_date from pa_proj_elem_ver_schedule where
487: element_version_id =
488: (select por.object_id_from1 from pa_proj_element_versions ppev,pa_object_relationships por
489: where ppev.proj_element_id = p_task_id
490: and ppev.element_version_id = por.object_id_to1

Line 672: select scheduled_start_date,scheduled_finish_date from pa_proj_elem_ver_schedule where

668: connect by prior task_id= parent_task_id;--Bug 6163119
669:
670: --bug 8566495 anuragag
671: cursor get_parent_dates(p_task_id NUMBER) is
672: select scheduled_start_date,scheduled_finish_date from pa_proj_elem_ver_schedule where
673: element_version_id =
674: (select por.object_id_from1 from pa_proj_element_versions ppev,pa_object_relationships por
675: where ppev.proj_element_id = p_task_id
676: and ppev.element_version_id = por.object_id_to1