[Home] [Help]
32: Begin
33:
34: Select nvl(gpt.sponsored_flag,'N')
35: into Sponsor_Flag
36: from pa_tasks t,
37: pa_projects_all p,
38: gms_project_types gpt
39: where t.task_id = P_Task_Id and
40: p.project_id = t.project_id and
256:
257: -- =================================================================================
258: -- BUG: 3358176 Award Distribution not recognized for sub tasks when funding
259: -- pattern is defined at top task level.
260: -- top_task_id and pa_tasks join was added.
261: -- =================================================================================
262: CURSOR FUND_PATTERN_EXIST IS
263: select fp.funding_name,
264: fp.funding_pattern_id
262: CURSOR FUND_PATTERN_EXIST IS
263: select fp.funding_name,
264: fp.funding_pattern_id
265: from gms_funding_patterns_all fp,
266: pa_tasks t
267: where nvl(fp.retroactive_flag, 'N') = 'N'
268: and NVL(fp.status, 'N') = 'A'
269: and fp.project_id = p_project_id
270: and t.task_id = p_task_id
277: where nvl(gfpa.retroactive_flag, 'N') = 'N'
278: and NVL(gfpa.status, 'N') = 'A'
279: and gfpa.project_id = p_project_id
280: and gfpa.task_id is null
281: and not exists (select '1' from gms_funding_patterns_all b, pa_tasks t
282: where gfpa.project_id = b.project_id
283: and nvl(b.status,'x') = 'A'
284: and t.task_id = p_task_id
285: and b.task_id = t.top_task_id)
493: -- BUG: 3628884 Performance issue due to non mergable view.
494: --
495: CURSOR GET_FUNDING_AWARD IS
496: select aw.award_id award_id
497: from pa_tasks t ,
498: gms_installments ins,
499: gms_summary_project_fundings su,
500: gms_budget_versions bv,
501: gms_awards aw