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 (x_funding_level varchar) 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: AND ((x_funding_level = 'T' and task_id is not null)

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

443: sum(nvl(project_allocated_amount,0)) proj_fund_amt
444: FROM pa_project_fundings
445: WHERE project_id = p_project_id
446: AND ((budget_type_code IN ('DRAFT', 'BASELINE')
447: AND PA_FUND_REVAL_PVT.G_REVAL_FLAG ='N')
448: OR (PA_FUND_REVAL_PVT.G_REVAL_FLAG ='Y'
449: AND (((budget_type_code ='BASELINE')
450: OR (budget_type_code ='DRAFT'
451: AND funding_category= 'REVALUATION')))))

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

444: FROM pa_project_fundings
445: WHERE project_id = p_project_id
446: AND ((budget_type_code IN ('DRAFT', 'BASELINE')
447: AND PA_FUND_REVAL_PVT.G_REVAL_FLAG ='N')
448: OR (PA_FUND_REVAL_PVT.G_REVAL_FLAG ='Y'
449: AND (((budget_type_code ='BASELINE')
450: OR (budget_type_code ='DRAFT'
451: AND funding_category= 'REVALUATION')))))
452: AND ((x_funding_level = 'T' and task_id is not null)