[Home] [Help]
1371:
1372: CURSOR check_budget(deliv_id IN NUMBER)
1373: IS
1374: SELECT DISTINCT 'Y'
1375: FROM ams_act_budgets
1376: WHERE arc_act_budget_used_by='DELV'
1377: AND act_budget_used_by_id = deliv_id;
1378:
1379: l_budget_lines_exist VARCHAR2(1) := 'N';
4482:
4483: CURSOR check_budget(deliv_id IN NUMBER)
4484: IS
4485: SELECT 'Y'
4486: FROM ams_act_budgets
4487: WHERE arc_act_budget_used_by='DELV'
4488: AND act_budget_used_by_id = deliv_id;
4489:
4490: l_currency_code VARCHAR2(15);