APPS.OZF_OFFER_ADJUSTMENT_PVT dependencies on OZF_ACT_BUDGETS

Line 66: WHERE fund_id IN ( SELECT budget_source_id FROM ozf_act_budgets where arc_act_budget_used_by = 'OFFR' and act_budget_used_by_id = p_qp_list_header_id);

62: RETURN DATE
63: IS
64: CURSOR c_budget_start_date(p_qp_list_header_id NUMBER) is
65: SELECT MIN(start_date_active) FROM ozf_funds_all_b
66: WHERE fund_id IN ( SELECT budget_source_id FROM ozf_act_budgets where arc_act_budget_used_by = 'OFFR' and act_budget_used_by_id = p_qp_list_header_id);
67: l_budget_start_date DATE;
68: BEGIN
69: OPEN c_budget_start_date(p_qp_list_header_id );
70: FETCH c_budget_start_date INTO l_budget_start_date;