APPS.PA_CE_INTEGRATION SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 24

    SELECT  pbl.start_date, pbl.end_date,
            nvl(pbl.raw_cost,0)/(pbl.end_date-pbl.start_date+1) per_day_raw_cost ,
            nvl(pbl.revenue,0)/(pbl.end_date-pbl.start_date+1) per_day_revenue
    FROM    pa_budget_lines pbl ,
            pa_resource_assignments pra ,
            pa_budget_versions pbv
    WHERE   decode(X_version,'C', pbv.current_flag,'O',pbv.current_original_flag)='Y'
    AND     pbl.end_date   >= X_period_start_date
    AND     pbl.start_date <= X_period_end_date
    AND     pbv.project_id  = X_project_id
    AND     pbv.budget_type_code = X_budget_type
    AND     pbl.resource_assignment_id = pra.resource_assignment_id
    AND     pra.budget_version_id = pbv.budget_version_id;

Line: 39

   SELECT org_id
   FROM   pa_projects_all
   WHERE  project_id = X_project_id;