DBA Data[Home] [Help]

APPS.PA_PROJ_ELEMENTS_UTILS dependencies on PA_EI_DENORM

Line 5503: FROM PA_EI_DENORM ped, table(cast(l_task_tbl as sub_task)) st

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);
5505: ELSE */
5506: SELECT
5507: 1 into l_dummy

Line 5515: FROM PA_EI_DENORM ped, table(cast(l_task_tbl as sub_task)) st

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);
5517: --END IF; commented for 16844815
5518: IF l_dummy = 1 THEN
5519: x_error_code :=50;