APPS.PA_BASELINE_FUNDING_PKG SQL Statements

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

Line: 42

                SELECT max(budget_version_id)
                FROM   pa_budget_versions
                WHERE project_id = p_project_id
                AND   budget_type_code = 'AR'
                AND   budget_status_code = 'W'
                AND   version_number = 1;

Line: 220

              SELECT task_id, sum(nvl(projfunc_allocated_amount,0)) fund_amt
              FROM  pa_project_fundings
              WHERE project_id = p_project_id
              AND ( (budget_type_code IN ('DRAFT', 'BASELINE') AND PA_FUND_REVAL_PVT.G_REVAL_FLAG ='N')
               OR   (PA_FUND_REVAL_PVT.G_REVAL_FLAG ='Y' AND (
					       ( (budget_type_code ='BASELINE') OR
						 (budget_type_code ='DRAFT' AND funding_category=
						'REVALUATION') ))))
              group by task_id;

Line: 261

                select start_date, completion_date
                into   l_start_date, l_end_date
                from   pa_tasks
                where  task_id = f1_rec.task_id
                and    project_id = p_project_id;

Line: 398

                SELECT R1.resource_list_id resource_list_id,
                       M.resource_list_member_id resource_list_member_id
                FROM   pa_resource_lists R1, pa_implementations I,
                       pa_resource_list_members M
                WHERE  R1.uncategorized_flag = 'Y'
                AND    R1.business_group_id = I.business_group_id
                AND    R1.resource_list_id = M.resource_list_id;

Line: 410

                SELECT R1.resource_list_id resource_list_id,
                       M.resource_list_member_id resource_list_member_id
                FROM   pa_resource_lists R1, pa_implementations I,
                       pa_resource_list_members M
                WHERE  R1.uncategorized_flag = 'Y'
                AND    R1.business_group_id = I.business_group_id
                AND    R1.resource_list_id = M.resource_list_id
                and    m.resource_class_code = 'FINANCIAL_ELEMENTS';

Line: 426

                SELECT start_date, completion_date
                FROM pa_projects_all
                WHERE project_id = p_project_id;

Line: 431

                SELECT task_id, sum(nvl(projfunc_allocated_amount,0)) pf_fund_amt,
                sum(nvl(project_allocated_amount,0)) proj_fund_amt
                FROM  pa_project_fundings
                WHERE project_id = p_project_id
                AND ((budget_type_code IN ('DRAFT', 'BASELINE')
                      AND PA_FUND_REVAL_PVT.G_REVAL_FLAG ='N')
                        OR   (PA_FUND_REVAL_PVT.G_REVAL_FLAG ='Y'
                              AND (((budget_type_code ='BASELINE')
                                     OR (budget_type_code ='DRAFT'
                                         AND funding_category= 'REVALUATION')))))
		AND nvl(PA_Funding_Core.G_FUND_BASELINE_FLAG,'N') ='N'
		-- FP_M changes: Added UNION clause for Change Management enhancements
		-- This cursor is modified to fetch only from the selected
		-- funding lines that needs to be baselined ONLY when
		-- a global value PA_Funding_Core.G_FUND_BASELINE_FLAG is enabled
		group by task_id
		UNION
		SELECT task_id,
		       sum(nvl(projfunc_allocated_amount,0)) pf_fund_amt,
		       sum(nvl(project_allocated_amount,0)) proj_fund_amt
		FROM  pa_project_fundings
		WHERE project_id = p_project_id
		AND   PA_Funding_Core.G_FUND_BASELINE_FLAG = 'Y'
		AND   (NVL(Submit_Baseline_Flag,'N') = 'Y' OR
		       budget_type_code = 'BASELINE' )
                group by task_id;

Line: 512

		SELECT	project_id
		INTO	l_project_id
		FROM	pa_projects_all
		WHERE	project_id = p_project_id
		FOR UPDATE NOWAIT;

Line: 654

				select start_date, completion_date
				into   l_start_date, l_end_date
				from   pa_tasks
				where  task_id = fp_rec.task_id
				and    project_id = p_project_id;

Line: 844

  Update PA_Project_Fundings
  SET    Submit_Baseline_Flag = 'Y'
  Where  Project_ID = P_Project_ID
  AND    Agreement_ID = P_Agreement_ID
  AND    CI_ID is null
  AND    Budget_Type_Code = 'DRAFT'
  AND    NVL(Submit_Baseline_Flag,'N') <> 'Y';

Line: 881

  Update PA_Project_Fundings
  SET    Submit_Baseline_Flag = 'Y'
  Where  Project_ID = P_Project_ID
  AND    CI_ID = P_CI_ID_Tab(ci_rec)
  AND    Budget_Type_Code = 'DRAFT'
  AND    NVL(Submit_Baseline_Flag,'N') <> 'Y';