DBA Data[Home] [Help]

APPS.PA_PROJ_ELEMENTS_UTILS dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 5500: FROM PA_EXPENDITURE_ITEMS_all pei,table(cast(l_alt_task_tbl as sub_task)) st --Changed the query for Bug#4964992

5496: FROM
5497: sys.dual
5498: WHERE
5499: exists (SELECT NULL
5500: FROM PA_EXPENDITURE_ITEMS_all pei,table(cast(l_alt_task_tbl as sub_task)) st --Changed the query for Bug#4964992
5501: WHERE pei.TASK_ID = st.task_id)
5502: or exists (SELECT NULL
5503: FROM PA_EI_DENORM ped, table(cast(l_task_tbl as sub_task)) st
5504: WHERE ped.TASK_ID = st.task_id);

Line 5512: FROM PA_EXPENDITURE_ITEMS_all pei,table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992

5508: FROM
5509: sys.dual
5510: WHERE
5511: exists (SELECT NULL
5512: FROM PA_EXPENDITURE_ITEMS_all pei,table(cast(l_task_tbl as sub_task)) st --Changed the query for Bug#4964992
5513: WHERE pei.TASK_ID = st.task_id)
5514: or exists (SELECT NULL
5515: FROM PA_EI_DENORM ped, table(cast(l_task_tbl as sub_task)) st
5516: WHERE ped.TASK_ID = st.task_id);