APPS.PA_ALLOC_UTILS dependencies on PA_ALLOC_TARGET_LINES

Line 118: FROM PA_ALLOC_TARGET_LINES TGTL

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
119: WHERE TGTL.project_id=p_project_id)
120: OR EXISTS
121: (SELECT 'Y'
122: FROM PA_ALLOC_RUN_SOURCES RSRC

Line 181: FROM PA_ALLOC_TARGET_LINES TGTL

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'
181: FROM PA_ALLOC_TARGET_LINES TGTL
182: WHERE TGTL.task_id=x_task_id;
183: CURSOR C_task_in_alloc_txn(x_task_id IN NUMBER) is
184: SELECT 'Y'
185: FROM PA_ALLOC_TXN_DETAILS TXN

Line 298: FROM PA_ALLOC_TARGET_LINES TGTL

294: FROM PA_ALLOC_RULES_ALL RULES
295: WHERE RULES.offset_task_id=p_task_id)
296: OR EXISTS
297: (SELECT '1'
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