APPS.PA_ALLOC_UTILS dependencies on PA_ALLOC_SOURCE_LINES

Line 114: FROM PA_ALLOC_SOURCE_LINES SRCL

110: FROM PA_ALLOC_RULES_ALL RULES
111: WHERE RULES.offset_project_id=p_project_id)
112: OR EXISTS
113: (SELECT 'Y'
114: FROM PA_ALLOC_SOURCE_LINES SRCL
115: WHERE SRCL.project_id=p_project_id)
116: OR EXISTS
117: ( SELECT 'Y'
118: FROM PA_ALLOC_TARGET_LINES TGTL

Line 176: FROM PA_ALLOC_SOURCE_LINES SRCL

172: WHERE RULES.offset_task_id=x_task_id;
173: /* Commented for bug 8929749
174: CURSOR C_task_in_alloc_src_line(x_task_id IN NUMBER) is
175: SELECT 'Y'
176: FROM PA_ALLOC_SOURCE_LINES SRCL
177: WHERE SRCL.task_id=x_task_id;
178: */
179: CURSOR C_task_in_alloc_tgt_line(x_task_id IN NUMBER) is
180: SELECT 'Y'

Line 309: FROM PA_ALLOC_SOURCE_LINES SRCL

305: CURSOR C_task_in_sources IS
306: SELECT '1'
307: FROM dual
308: WHERE EXISTS (SELECT '1'
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