APPS.PA_BASELINE_FUNDING_PKG dependencies on PA_FUND_REVAL_PVT

Line 223: AND ( (budget_type_code IN ('DRAFT', 'BASELINE') AND PA_FUND_REVAL_PVT.G_REVAL_FLAG ='N')

219: CURSOR funding_amount is
220: SELECT task_id, sum(nvl(projfunc_allocated_amount,0)) fund_amt
221: FROM pa_project_fundings
222: WHERE project_id = p_project_id
223: AND ( (budget_type_code IN ('DRAFT', 'BASELINE') AND PA_FUND_REVAL_PVT.G_REVAL_FLAG ='N')
224: OR (PA_FUND_REVAL_PVT.G_REVAL_FLAG ='Y' AND (
225: ( (budget_type_code ='BASELINE') OR
226: (budget_type_code ='DRAFT' AND funding_category=
227: 'REVALUATION') ))))

Line 224: OR (PA_FUND_REVAL_PVT.G_REVAL_FLAG ='Y' AND (

220: SELECT task_id, sum(nvl(projfunc_allocated_amount,0)) fund_amt
221: FROM pa_project_fundings
222: WHERE project_id = p_project_id
223: AND ( (budget_type_code IN ('DRAFT', 'BASELINE') AND PA_FUND_REVAL_PVT.G_REVAL_FLAG ='N')
224: OR (PA_FUND_REVAL_PVT.G_REVAL_FLAG ='Y' AND (
225: ( (budget_type_code ='BASELINE') OR
226: (budget_type_code ='DRAFT' AND funding_category=
227: 'REVALUATION') ))))
228: group by task_id;

Line 436: AND PA_FUND_REVAL_PVT.G_REVAL_FLAG ='N')

432: sum(nvl(project_allocated_amount,0)) proj_fund_amt
433: FROM pa_project_fundings
434: WHERE project_id = p_project_id
435: AND ((budget_type_code IN ('DRAFT', 'BASELINE')
436: AND PA_FUND_REVAL_PVT.G_REVAL_FLAG ='N')
437: OR (PA_FUND_REVAL_PVT.G_REVAL_FLAG ='Y'
438: AND (((budget_type_code ='BASELINE')
439: OR (budget_type_code ='DRAFT'
440: AND funding_category= 'REVALUATION')))))

Line 437: OR (PA_FUND_REVAL_PVT.G_REVAL_FLAG ='Y'

433: FROM pa_project_fundings
434: WHERE project_id = p_project_id
435: AND ((budget_type_code IN ('DRAFT', 'BASELINE')
436: AND PA_FUND_REVAL_PVT.G_REVAL_FLAG ='N')
437: OR (PA_FUND_REVAL_PVT.G_REVAL_FLAG ='Y'
438: AND (((budget_type_code ='BASELINE')
439: OR (budget_type_code ='DRAFT'
440: AND funding_category= 'REVALUATION')))))
441: AND nvl(PA_Funding_Core.G_FUND_BASELINE_FLAG,'N') ='N'