APPS.PA_CE_INTEGRATION dependencies on PA_RESOURCE_ASSIGNMENTS

Line 28: pa_resource_assignments pra ,

24: SELECT pbl.start_date, pbl.end_date,
25: nvl(pbl.raw_cost,0)/(pbl.end_date-pbl.start_date+1) per_day_raw_cost ,
26: nvl(pbl.revenue,0)/(pbl.end_date-pbl.start_date+1) per_day_revenue
27: FROM pa_budget_lines pbl ,
28: pa_resource_assignments pra ,
29: pa_budget_versions pbv
30: WHERE decode(X_version,'C', pbv.current_flag,'O',pbv.current_original_flag)='Y'
31: AND pbl.end_date >= X_period_start_date
32: AND pbl.start_date <= X_period_end_date