APPS.OZF_OFFER_ADJUSTMENT_PVT dependencies on OZF_ACT_BUDGETS

Line 67: 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);

63: RETURN DATE
64: IS
65: CURSOR c_budget_start_date(p_qp_list_header_id NUMBER) is
66: SELECT MIN(start_date_active) FROM ozf_funds_all_b
67: 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);
68: l_budget_start_date DATE;
69: BEGIN
70: OPEN c_budget_start_date(p_qp_list_header_id );
71: FETCH c_budget_start_date INTO l_budget_start_date;