DBA Data[Home] [Help]

APPS.OZF_OFFER_ADJUSTMENT_PVT dependencies on OZF_FUNDS_ALL_B

Line 66: SELECT MIN(start_date_active) FROM ozf_funds_all_b

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