APPS.OZF_FUND_ADJUSTMENT_PVT dependencies on OZF_REQUEST_HEADERS_ALL_B

Line 2442: FROM ozf_request_headers_all_b

2438: AND utilization_type ='ACCRUAL';
2439:
2440: CURSOR c_req_date(p_offer_id IN NUMBER) IS
2441: SELECT request_header_id
2442: FROM ozf_request_headers_all_b
2443: WHERE offer_id =p_offer_id;
2444:
2445: /*
2446: CURSOR c_get_cust_account_id(p_party_id IN NUMBER) IS

Line 4116: FROM ozf_request_headers_all_b req, ozf_offers off

4112: l_offer_org_id NUMBER;
4113: --get request date and currency.
4114: CURSOR c_request_date(p_offer_id IN NUMBER) IS
4115: SELECT req.request_header_id, req.currency_code,off.qualifier_id, req.submitted_by,off.org_id --approved_by
4116: FROM ozf_request_headers_all_b req, ozf_offers off
4117: WHERE req.offer_id =p_offer_id
4118: AND req.offer_id = off.qp_list_header_id;
4119:
4120: --get expense information.

Line 4402: FROM ozf_request_headers_all_b

4398: p_offer_is IN NUMBER
4399: ) IS
4400: CURSOR c_req_header_rec(p_offer_id IN NUMBER) IS
4401: SELECT request_header_id,object_version_number,status_code
4402: FROM ozf_request_headers_all_b
4403: WHERE offer_id = p_offer_id;
4404:
4405: l_req_header_id NUMBER;
4406: l_obj_ver_num NUMBER;

Line 4425: UPDATE ozf_request_headers_all_b

4421: l_status_code;
4422: CLOSE c_req_header_rec;
4423:
4424: IF l_status_code <> 'APPROVED' THEN
4425: UPDATE ozf_request_headers_all_b
4426: SET status_code ='APPROVED',
4427: object_version_number = l_obj_ver_num + 1
4428: WHERE request_header_id = l_req_header_id;
4429: END IF;