APPS.PA_VRM_UTILS SQL Statements

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

Line: 14

 select VERSION_NUMBER from PA_BUDGET_VERSIONS pbv
 where PROJECT_ID = p_project_id
 and pbv.APPROVED_REV_PLAN_TYPE_FLAG ='Y'
 AND pbv.ci_id       IS NULL
 and pbv.VERSION_NUMBER = c_prev_version_number
 and pbv.BUDGET_STATUS_CODE = 'B';

Line: 22

 select REVENUE from PA_BUDGET_VERSIONS pbv
 where PROJECT_ID = p_project_id
 and pbv.APPROVED_REV_PLAN_TYPE_FLAG ='Y'
 AND pbv.ci_id       IS NULL
 and pbv.VERSION_NUMBER = p_current_version_number
 and pbv.BUDGET_STATUS_CODE = 'B';

Line: 30

 select pbv.REVENUE - (select pbv1.REVENUE from PA_BUDGET_VERSIONS pbv1
 where pbv1.PROJECT_ID = pbv.PROJECT_ID and pbv1.APPROVED_REV_PLAN_TYPE_FLAG = 'Y'
 AND pbv.ci_id       IS NULL
 and pbv1.VERSION_NUMBER = c_prev_version_number and BUDGET_STATUS_CODE = 'B')
 from PA_BUDGET_VERSIONS pbv where project_id = p_project_id and
 pbv.APPROVED_REV_PLAN_TYPE_FLAG ='Y' and pbv.BUDGET_STATUS_CODE = 'B'
 and pbv.VERSION_NUMBER = p_current_version_number;

Line: 81

 select VERSION_NUMBER from PA_BUDGET_VERSIONS pbv
 where PROJECT_ID = p_project_id
 and pbv.APPROVED_COST_PLAN_TYPE_FLAG ='Y'
 AND pbv.ci_id       IS NULL
 and pbv.VERSION_NUMBER = c_prev_version_number
 and pbv.BUDGET_STATUS_CODE = 'B';

Line: 89

 select BURDENED_COST from PA_BUDGET_VERSIONS pbv
 where PROJECT_ID = p_project_id
 and pbv.APPROVED_COST_PLAN_TYPE_FLAG ='Y'
 AND pbv.ci_id       IS NULL
 and pbv.VERSION_NUMBER = p_current_version_number
 and pbv.BUDGET_STATUS_CODE = 'B';

Line: 97

 select pbv.BURDENED_COST - (select pbv1.BURDENED_COST from PA_BUDGET_VERSIONS pbv1
 where pbv1.PROJECT_ID = pbv.PROJECT_ID and pbv1.APPROVED_COST_PLAN_TYPE_FLAG = 'Y'
 AND pbv.ci_id       IS NULL
 and pbv1.VERSION_NUMBER = c_prev_version_number and BUDGET_STATUS_CODE = 'B')
 from PA_BUDGET_VERSIONS pbv where project_id = p_project_id and
 pbv.APPROVED_COST_PLAN_TYPE_FLAG ='Y' and pbv.BUDGET_STATUS_CODE = 'B'
 and pbv.VERSION_NUMBER = p_current_version_number;

Line: 150

 select VERSION_NUMBER from PA_BUDGET_VERSIONS pbv
 where PROJECT_ID = p_project_id
 and pbv.APPROVED_COST_PLAN_TYPE_FLAG ='Y'
 AND pbv.ci_id       IS NULL
 and pbv.VERSION_NUMBER = c_prev_version_number
 and pbv.BUDGET_STATUS_CODE = 'B';

Line: 158

 select VERSION_NUMBER from PA_BUDGET_VERSIONS pbv
 where PROJECT_ID = p_project_id
 and pbv.APPROVED_REV_PLAN_TYPE_FLAG ='Y'
 AND pbv.ci_id       IS NULL
 and pbv.VERSION_NUMBER = c_prev_version_number
 and pbv.BUDGET_STATUS_CODE = 'B';

Line: 214

 select BUDGET_VERSION_ID from PA_BUDGET_VERSIONS pbv
 where PROJECT_ID = p_project_id
 and pbv.APPROVED_REV_PLAN_TYPE_FLAG ='Y'
 AND pbv.ci_id       IS NULL
 and pbv.VERSION_NUMBER = (select min(VERSION_NUMBER) from PA_BUDGET_VERSIONS where PROJECT_ID = p_project_id
 AND APPROVED_REV_PLAN_TYPE_FLAG ='Y' AND ci_id IS NULL AND BUDGET_STATUS_CODE = 'B')
 and pbv.BUDGET_STATUS_CODE = 'B';