DBA Data[Home] [Help]

APPS.PA_BILLING_PROCESS_PKG dependencies on PA_EXPENDITURE_ITEMS_ALL

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