APPS.PA_ALLOC_UTILS dependencies on PA_ALLOC_TXN_DETAILS

Line 106: FROM PA_ALLOC_TXN_DETAILS TXN

102: CURSOR C_project_in_allocations is
103: SELECT '1'
104: FROM dual
105: WHERE EXISTS (SELECT 'Y'
106: FROM PA_ALLOC_TXN_DETAILS TXN
107: WHERE TXN.project_id=p_project_id)
108: OR EXISTS
109: (SELECT 'Y'
110: FROM PA_ALLOC_RULES_ALL RULES

Line 183: FROM PA_ALLOC_TXN_DETAILS TXN

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
184: WHERE TXN.task_id=x_task_id;
185: CURSOR C_task_in_alloc_run_src(x_task_id IN NUMBER) is
186: SELECT 'Y'
187: FROM PA_ALLOC_RUN_SOURCES RSRC

Line 286: FROM PA_ALLOC_TXN_DETAILS TXN

282: CURSOR C_task_in_targets_offsets IS
283: SELECT '1'
284: FROM dual
285: WHERE EXISTS (SELECT '1'
286: FROM PA_ALLOC_TXN_DETAILS TXN
287: WHERE TXN.task_id=p_task_id)
288: OR EXISTS
289: ( SELECT '1'
290: FROM PA_ALLOC_RULES_ALL RULES