DBA Data[Home] [Help]

APPS.PA_ALLOC_UTILS dependencies on PA_ALLOC_RUN_SOURCES

Line 122: FROM PA_ALLOC_RUN_SOURCES RSRC

118: FROM PA_ALLOC_TARGET_LINES TGTL
119: WHERE TGTL.project_id=p_project_id)
120: OR EXISTS
121: (SELECT 'Y'
122: FROM PA_ALLOC_RUN_SOURCES RSRC
123: WHERE RSRC.project_id=p_project_id)
124: OR EXISTS
125: (SELECT 'Y'
126: FROM PA_ALLOC_RUN_TARGETS RTGT

Line 187: FROM PA_ALLOC_RUN_SOURCES RSRC

183: FROM PA_ALLOC_TXN_DETAILS TXN
184: WHERE TXN.task_id=x_task_id;
185: CURSOR C_task_in_alloc_run_src(x_task_id IN NUMBER) is
186: SELECT 'Y'
187: FROM PA_ALLOC_RUN_SOURCES RSRC
188: WHERE RSRC.task_id=x_task_id;
189: CURSOR C_task_in_alloc_run_tgt(x_task_id IN NUMBER) is
190: SELECT 'Y'
191: FROM PA_ALLOC_RUN_TARGETS RTGT

Line 309: FROM PA_ALLOC_RUN_SOURCES RSRC

305: FROM PA_ALLOC_SOURCE_LINES SRCL
306: WHERE SRCL.task_id=p_task_id)
307: OR EXISTS
308: ( SELECT '1'
309: FROM PA_ALLOC_RUN_SOURCES RSRC
310: WHERE RSRC.task_id=p_task_id);
311:
312: CURSOR C_top_task(p_tsk_id IN NUMBER) IS
313: SELECT top_task_id