APPS.PA_BILLING_PROCESS_PKG dependencies on PA_EXPENDITURE_ITEMS

Line 195: SELECT /*+ INDEX(Rtask PA_TASKS_N8) INDEX(ei PA_EXPENDITURE_ITEMS_N9)*/ 1

191: SELECT 1
192: INTO temp
193: FROM dual
194: WHERE EXISTS(
195: SELECT /*+ INDEX(Rtask PA_TASKS_N8) INDEX(ei PA_EXPENDITURE_ITEMS_N9)*/ 1
196: FROM pa_expenditure_items_all ei,
197: pa_tasks Rtask
198: WHERE Rtask.project_id = Rproj.project_id
199: AND ei.project_id = Rproj.project_id /* 14727962 */

Line 196: FROM pa_expenditure_items_all ei,

192: INTO temp
193: FROM dual
194: WHERE EXISTS(
195: SELECT /*+ INDEX(Rtask PA_TASKS_N8) INDEX(ei PA_EXPENDITURE_ITEMS_N9)*/ 1
196: FROM pa_expenditure_items_all ei,
197: pa_tasks Rtask
198: WHERE Rtask.project_id = Rproj.project_id
199: AND ei.project_id = Rproj.project_id /* 14727962 */
200: AND ei.task_id = Rtask.task_id

Line 237: FROM pa_expenditure_items ei2

233:
234: /* 14727962 */
235: UNION ALL
236: SELECT 1
237: FROM pa_expenditure_items ei2
238: WHERE ei2.project_id = ei.project_id
239: AND ei2.expenditure_item_id = ei.adjusted_expenditure_item_id
240: AND ei2.revenue_distributed_flag = 'Y'
241: AND ei2.raw_revenue = 0