APPS.OZF_BUDGETAPPROVAL_PVT dependencies on OZF_APPROVAL_ACCESS

Line 338: UPDATE ozf_approval_access

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

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

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