[Home] [Help]
33:
34: --Bug 9090618 added org_id join between p and gpt
35: Select nvl(gpt.sponsored_flag,'N')
36: into Sponsor_Flag
37: from pa_tasks t,
38: pa_projects_all p,
39: --gms_project_types gpt /*Commented for bug#12822370 */
40: pa_project_types_all gpt /*Added for bug#12822370 */
41: where t.task_id = P_Task_Id and
259:
260: -- =================================================================================
261: -- BUG: 3358176 Award Distribution not recognized for sub tasks when funding
262: -- pattern is defined at top task level.
263: -- top_task_id and pa_tasks join was added.
264: -- =================================================================================
265: CURSOR FUND_PATTERN_EXIST IS
266: select fp.funding_name,
267: fp.funding_pattern_id
265: CURSOR FUND_PATTERN_EXIST IS
266: select fp.funding_name,
267: fp.funding_pattern_id
268: from gms_funding_patterns_all fp,
269: pa_tasks t
270: where nvl(fp.retroactive_flag, 'N') = 'N'
271: and NVL(fp.status, 'N') = 'A'
272: and fp.project_id = p_project_id
273: and t.task_id = p_task_id
280: where nvl(gfpa.retroactive_flag, 'N') = 'N'
281: and NVL(gfpa.status, 'N') = 'A'
282: and gfpa.project_id = p_project_id
283: and gfpa.task_id is null
284: and not exists (select '1' from gms_funding_patterns_all b, pa_tasks t
285: where gfpa.project_id = b.project_id
286: and nvl(b.status,'x') = 'A'
287: and t.task_id = p_task_id
288: and b.task_id = t.top_task_id)
499: -- BUG: 3628884 Performance issue due to non mergable view.
500: --
501: CURSOR GET_FUNDING_AWARD IS
502: select aw.award_id award_id
503: from pa_tasks t ,
504: gms_installments ins,
505: gms_summary_project_fundings su,
506: gms_budget_versions bv,
507: gms_awards_all aw --- Added for Bug#13370217