DBA Data[Home] [Help]

APPS.AMS_DELIVERABLE_PVT dependencies on AMS_ACT_BUDGETS

Line 1388: FROM ams_act_budgets

1384:
1385: CURSOR check_budget(deliv_id IN NUMBER)
1386: IS
1387: SELECT DISTINCT 'Y'
1388: FROM ams_act_budgets
1389: WHERE arc_act_budget_used_by='DELV'
1390: AND act_budget_used_by_id = deliv_id;
1391:
1392: l_budget_lines_exist VARCHAR2(1) := 'N';

Line 4499: FROM ams_act_budgets

4495:
4496: CURSOR check_budget(deliv_id IN NUMBER)
4497: IS
4498: SELECT 'Y'
4499: FROM ams_act_budgets
4500: WHERE arc_act_budget_used_by='DELV'
4501: AND act_budget_used_by_id = deliv_id;
4502:
4503: l_currency_code VARCHAR2(15);