DBA Data[Home] [Help]

APPS.OZF_OFFER_ADJUSTMENT_PVT dependencies on OZF_FUNDS_ALL_B

Line 65: SELECT MIN(start_date_active) FROM ozf_funds_all_b

61: ( p_qp_list_header_id IN NUMBER)
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 );