DBA Data[Home] [Help]

APPS.AMS_DELIVERABLE_PVT dependencies on AMS_ACT_BUDGETS

Line 1375: FROM ams_act_budgets

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';

Line 4486: FROM ams_act_budgets

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);