337:
338: l_stage := 'Deriving values : EXP/REV CAT';
339:
340: -- ## NOTE: exp category and rev cateogry are being derived at one shot
341: -- ## so that we do not have query pa_expenditure_types again
342:
343: If x_expenditure_type is not null then
344:
345: Select expenditure_category,
345: Select expenditure_category,
346: revenue_category_code
347: into l_expenditure_category,
348: l_revenue_category
349: from pa_expenditure_types
350: where expenditure_type = x_expenditure_type;
351:
352: End if;
353:
583: Select expenditure_category,
584: revenue_category_code
585: into l_expenditure_category,
586: l_revenue_category
587: from pa_expenditure_types
588: where expenditure_type = x_expenditure_type;
589:
590: End if;
591:
607: Select expenditure_category,
608: revenue_category_code
609: into l_expenditure_category,
610: l_revenue_category
611: from pa_expenditure_types
612: where expenditure_type = x_expenditure_type;
613:
614: Elsif (x_expenditure_type is null and x_event_type is not null) then
615:
1353:
1354: l_stage := 'Deriving values : EXP/REV CAT';
1355:
1356: -- ## NOTE: exp category and rev cateogry are being derived at one shot
1357: -- ## so that we do not have query pa_expenditure_types again
1358:
1359: If x_expenditure_type is not null then
1360:
1361: l_expenditure_category := x_expenditure_category;