APPS.PA_PROJ_ELEMENTS_UTILS dependencies on PA_ALTERNATE_TASKS

Line 5422: select alt_task_id from pa_alternate_tasks,table(cast(l_task_tbl as sub_task)) st

5418: l_alt_task_tbl sub_task; --bug#16461684
5419: l_tmp_task_tbl sub_task; --bug#16461684
5420:
5421: cursor alt_task_cur ( l_task_tbl sub_task ) is
5422: select alt_task_id from pa_alternate_tasks,table(cast(l_task_tbl as sub_task)) st
5423: where proj_element_id = st.task_id ;
5424:
5425: BEGIN
5426: x_error_code := 0;

Line 6093: pa_alternate_tasks where

6089: CURSOR task_hierarchy IS
6090: SELECT
6091: task_rec(null,alt_task_id)
6092: FROM
6093: pa_alternate_tasks where
6094: proj_element_id in (select task_id from
6095: pa_tasks
6096: CONNECT BY PRIOR
6097: task_id = parent_task_id AND