APPS.OZF_FUND_ADJUSTMENT_PVT dependencies on OZF_REQUEST_HEADERS_ALL_B

Line 1920: FROM ozf_request_headers_all_b

1916: AND utilization_type ='ACCRUAL';
1917:
1918: CURSOR c_req_date(p_offer_id IN NUMBER) IS
1919: SELECT request_header_id
1920: FROM ozf_request_headers_all_b
1921: WHERE offer_id =p_offer_id;
1922:
1923: /*
1924: CURSOR c_get_cust_account_id(p_party_id IN NUMBER) IS

Line 3438: FROM ozf_request_headers_all_b req, ozf_offers off

3434: l_offer_org_id NUMBER;
3435: --get request date and currency.
3436: CURSOR c_request_date(p_offer_id IN NUMBER) IS
3437: SELECT req.request_header_id, req.currency_code,off.qualifier_id, req.submitted_by,off.org_id --approved_by
3438: FROM ozf_request_headers_all_b req, ozf_offers off
3439: WHERE req.offer_id =p_offer_id
3440: AND req.offer_id = off.qp_list_header_id;
3441:
3442: --get expense information.

Line 3720: FROM ozf_request_headers_all_b

3716: p_offer_is IN NUMBER
3717: ) IS
3718: CURSOR c_req_header_rec(p_offer_id IN NUMBER) IS
3719: SELECT request_header_id,object_version_number,status_code
3720: FROM ozf_request_headers_all_b
3721: WHERE offer_id = p_offer_id;
3722:
3723: l_req_header_id NUMBER;
3724: l_obj_ver_num NUMBER;

Line 3743: UPDATE ozf_request_headers_all_b

3739: l_status_code;
3740: CLOSE c_req_header_rec;
3741:
3742: IF l_status_code <> 'APPROVED' THEN
3743: UPDATE ozf_request_headers_all_b
3744: SET status_code ='APPROVED',
3745: object_version_number = l_obj_ver_num + 1
3746: WHERE request_header_id = l_req_header_id;
3747: END IF;