DBA Data[Home] [Help]

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 195: FROM PA_ALLOC_RUN_TARGETS RTGT

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'
195: FROM PA_ALLOC_RUN_TARGETS RTGT
196: WHERE RTGT.task_id=x_task_id;
197:
198: v_ret_code varchar2(1) := 'N';
199:

Line 302: FROM PA_ALLOC_RUN_TARGETS RTGT

298: FROM PA_ALLOC_TARGET_LINES TGTL
299: WHERE TGTL.task_id=p_task_id)
300: OR EXISTS
301: (SELECT '1'
302: FROM PA_ALLOC_RUN_TARGETS RTGT
303: WHERE RTGT.task_id=p_task_id);
304:
305: CURSOR C_task_in_sources IS
306: SELECT '1'