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 185: FROM PA_ALLOC_TXN_DETAILS TXN

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
186: WHERE TXN.task_id=x_task_id;
187: /* Commented for bug 8929749
188: CURSOR C_task_in_alloc_run_src(x_task_id IN NUMBER) is
189: SELECT 'Y'

Line 290: FROM PA_ALLOC_TXN_DETAILS TXN

286: CURSOR C_task_in_targets_offsets IS
287: SELECT '1'
288: FROM dual
289: WHERE EXISTS (SELECT '1'
290: FROM PA_ALLOC_TXN_DETAILS TXN
291: WHERE TXN.task_id=p_task_id)
292: OR EXISTS
293: ( SELECT '1'
294: FROM PA_ALLOC_RULES_ALL RULES