[Home] [Help]
57: BEGIN
58: --dbms_output.put_line('NO MONEY!!!');
59: select 1
60: into dummy
61: from dual
62: where exists ( select 1
63: from pa_project_fundings
64: where agreement_id = p_agreement_id);
65:
282: IF p_task_id is not null THEN
283: --dbms_output.put_line('Task id is not null');
284: Select 1
285: Into task_exists
286: From Dual
287: Where exists(
288: select task_name, task_number, task_id
289: from pa_tasks_top_v
290: where project_id = p_project_id
426:
427: BEGIN
428: -- Any expenditure item is revenue distributed ?
429: /* Commented for Bug 3457824
430: select 'N' into v_valid_level_change from dual
431: where exists
432: (select T.project_id
433: from pa_expenditure_items E, pa_tasks T
434: where T.project_id = p_project_id
437: */
438:
439: /* Code Added for Bug 3457824 starts here */
440:
441: select 'N' into v_valid_level_change from dual
442: where exists
443: (select E.project_id
444: from pa_expenditure_items E
445: where E.project_id = p_project_id
460: -- Any event is revenue distributed?
461:
462: SELECT 'N'
463: INTO v_valid_level_change
464: FROM DUAL
465: WHERE EXISTS (
466: SELECT project_id FROM PA_EVENTS
467: WHERE project_id = p_project_id AND
468: revenue_distributed_flag ='Y');
1784:
1785: BEGIN
1786:
1787: SELECT 'Y' into l_mult_funding_flag
1788: FROM dual
1789: WHERE exists ( select null
1790: FROM PA_SUMMARY_PROJECT_FUNDINGS spf
1791: WHERE spf.project_id = p_project_id
1792: AND spf.funding_currency_code <> p_funding_currency_code