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 190: FROM PA_ALLOC_RUN_SOURCES RSRC

186: WHERE TXN.task_id=x_task_id;
187: /* Commented for bug 8929749
188: CURSOR C_task_in_alloc_run_src(x_task_id IN NUMBER) is
189: SELECT 'Y'
190: FROM PA_ALLOC_RUN_SOURCES RSRC
191: WHERE RSRC.task_id=x_task_id;
192: */
193: CURSOR C_task_in_alloc_run_tgt(x_task_id IN NUMBER) is
194: SELECT 'Y'

Line 313: FROM PA_ALLOC_RUN_SOURCES RSRC

309: FROM PA_ALLOC_SOURCE_LINES SRCL
310: WHERE SRCL.task_id=p_task_id)
311: OR EXISTS
312: ( SELECT '1'
313: FROM PA_ALLOC_RUN_SOURCES RSRC
314: WHERE RSRC.task_id=p_task_id);
315:
316: CURSOR C_top_task(p_tsk_id IN NUMBER) IS
317: SELECT top_task_id