APPS.OZF_OFFER_PVT dependencies on OZF_APPROVAL_ACCESS

Line 3998: UPDATE ozf_approval_access

3994: x_amount_error := 'Y';
3995: END IF; -- end called from 'R'
3996:
3997: IF p_offer_rec.custom_setup_id = 110 THEN
3998: UPDATE ozf_approval_access
3999: SET action_code = NULL
4000: , action_date = NULL
4001: , action_performed_by = NULL
4002: , workflow_itemkey = NULL

Line 4009: FROM ozf_approval_access apr

4005: , last_update_date = sysdate
4006: , last_updated_by = FND_GLOBAL.user_id
4007: WHERE approval_access_id IN
4008: (SELECT apr.approval_access_id
4009: FROM ozf_approval_access apr
4010: , ozf_request_headers_all_b req
4011: , jtf_rs_resource_extns jre
4012: WHERE req.request_header_id = apr.object_id
4013: AND apr.object_id = req.request_header_id