APPS.PA_ALLOC_UTILS dependencies on PA_ALLOC_RUN_TARGETS

Line 126: FROM PA_ALLOC_RUN_TARGETS RTGT

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
127: WHERE RTGT.project_id=p_project_id);
128:
129: v_ret_code varchar2(1) ;
130: v_dummy varchar2(1);

Line 191: FROM PA_ALLOC_RUN_TARGETS RTGT

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
192: WHERE RTGT.task_id=x_task_id;
193:
194: v_ret_code varchar2(1) := 'N';
195:

Line 298: FROM PA_ALLOC_RUN_TARGETS RTGT

294: FROM PA_ALLOC_TARGET_LINES TGTL
295: WHERE TGTL.task_id=p_task_id)
296: OR EXISTS
297: (SELECT '1'
298: FROM PA_ALLOC_RUN_TARGETS RTGT
299: WHERE RTGT.task_id=p_task_id);
300:
301: CURSOR C_task_in_sources IS
302: SELECT '1'