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 175: FROM PA_ALLOC_SOURCE_LINES SRCL

171: FROM PA_ALLOC_RULES_ALL RULES
172: WHERE RULES.offset_task_id=x_task_id;
173: CURSOR C_task_in_alloc_src_line(x_task_id IN NUMBER) is
174: SELECT 'Y'
175: FROM PA_ALLOC_SOURCE_LINES SRCL
176: WHERE SRCL.task_id=x_task_id;
177: CURSOR C_task_in_alloc_tgt_line(x_task_id IN NUMBER) is
178: SELECT 'Y'
179: FROM PA_ALLOC_TARGET_LINES TGTL

Line 305: FROM PA_ALLOC_SOURCE_LINES SRCL

301: CURSOR C_task_in_sources IS
302: SELECT '1'
303: FROM dual
304: WHERE EXISTS (SELECT '1'
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