APPS.OZF_BUDGETAPPROVAL_PVT dependencies on OZF_APPROVAL_ACCESS

Line 334: UPDATE ozf_approval_access

330: FETCH c_req_rec INTO l_request_header_id;
331: CLOSE c_req_rec;
332:
333: IF l_request_header_id is NOT NULL THEN
334: UPDATE ozf_approval_access
335: SET approval_access_flag = 'Y'
336: WHERE object_type ='SOFT_FUND'
337: AND object_id = l_request_header_id
338: AND approval_level = (SELECT min(approval_level) from ozf_approval_access WHERE object_type ='SOFT_FUND'

Line 338: AND approval_level = (SELECT min(approval_level) from ozf_approval_access WHERE object_type ='SOFT_FUND'

334: UPDATE ozf_approval_access
335: SET approval_access_flag = 'Y'
336: WHERE object_type ='SOFT_FUND'
337: AND object_id = l_request_header_id
338: AND approval_level = (SELECT min(approval_level) from ozf_approval_access WHERE object_type ='SOFT_FUND'
339: AND object_id = l_request_header_id );
340: END IF;
341:
342: OZF_ActBudgets_PVT.Init_Act_Budgets_Rec (l_act_budgets_rec);