APPS.OZF_UTILITY_PVT dependencies on OZF_ACT_BUDGETS

Line 2430: FROM ozf_act_budgets

2426:
2427: --Bugfix: 7555174, 7415805 (Start)
2428: CURSOR C_GET_OFFERS_BUDGET_ID(p_list_header_id IN NUMBER)IS
2429: SELECT budget_source_id, budget_source_type
2430: FROM ozf_act_budgets
2431: WHERE act_budget_used_by_id=p_list_header_id;
2432:
2433: CURSOR c_camp_budget_id(p_campaign_id IN NUMBER) IS
2434: SELECT budget_source_id

Line 2435: FROM ozf_act_budgets

2431: WHERE act_budget_used_by_id=p_list_header_id;
2432:
2433: CURSOR c_camp_budget_id(p_campaign_id IN NUMBER) IS
2434: SELECT budget_source_id
2435: FROM ozf_act_budgets
2436: WHERE act_budget_used_by_id = p_campaign_id;
2437:
2438: l_budget_source_id NUMBER;
2439: l_budget_source_type VARCHAR2(30);

Line 3316: FROM ozf_funds_utilized_all_b uti, ozf_act_budgets act

3312: /*
3313: SELECT SUM(AMOUNT)
3314: FROM(
3315: SELECT uti.plan_curr_amount amount
3316: FROM ozf_funds_utilized_all_b uti, ozf_act_budgets act
3317: WHERE uti.utilization_type ='REQUEST'
3318: AND component_type = 'OFFR'
3319: AND component_id = list_header_id
3320: AND act.activity_budget_id = uti.ams_activity_budget_id

Line 3324: FROM ozf_funds_utilized_all_b uti, ozf_act_budgets act

3320: AND act.activity_budget_id = uti.ams_activity_budget_id
3321: AND act.recal_flag is NULL
3322: UNION ALL
3323: SELECT 0-uti.plan_curr_amount amount
3324: FROM ozf_funds_utilized_all_b uti, ozf_act_budgets act
3325: WHERE uti.utilization_type ='TRANSFER'
3326: AND plan_type = 'OFFR'
3327: AND plan_id = list_header_id
3328: AND act.activity_budget_id = uti.ams_activity_budget_id