DBA Data[Home] [Help]

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 179: FROM PA_ALLOC_TARGET_LINES TGTL

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

Line 294: FROM PA_ALLOC_TARGET_LINES TGTL

290: FROM PA_ALLOC_RULES_ALL RULES
291: WHERE RULES.offset_task_id=p_task_id)
292: OR EXISTS
293: (SELECT '1'
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