APPS.OZF_OFFER_PVT dependencies on OZF_APPROVAL_ACCESS

Line 3817: UPDATE ozf_approval_access

3813: x_amount_error := 'Y';
3814: END IF; -- end called from 'R'
3815:
3816: IF p_offer_rec.custom_setup_id = 110 THEN
3817: UPDATE ozf_approval_access
3818: SET action_code = NULL
3819: , action_date = NULL
3820: , action_performed_by = NULL
3821: , workflow_itemkey = NULL

Line 3828: FROM ozf_approval_access apr

3824: , last_update_date = sysdate
3825: , last_updated_by = FND_GLOBAL.user_id
3826: WHERE approval_access_id IN
3827: (SELECT apr.approval_access_id
3828: FROM ozf_approval_access apr
3829: , ozf_request_headers_all_b req
3830: , jtf_rs_resource_extns jre
3831: WHERE req.request_header_id = apr.object_id
3832: AND apr.object_id = req.request_header_id