APPS.OZF_PRE_PROCESS_PVT dependencies on OZF_REQUEST_HEADERS_ALL_B

Line 2244: FROM ozf_request_headers_all_b

2240: ANd b.list_header_id = cv_price_list_id;
2241:
2242: CURSOR spr_org(cv_reqeust_header_id IN NUMBER) IS
2243: SELECT org_id
2244: FROM ozf_request_headers_all_b
2245: WHERE request_header_id = cv_reqeust_header_id;
2246:
2247: l_exchange_rate_type VARCHAR2(100);
2248: l_exchange_rate NUMBER;

Line 4021: FROM ozf_request_headers_all_b

4017:
4018: CURSOR get_spo_agreement_name_csr(pc_agreement_id NUMBER)
4019: IS
4020: SELECT agreement_number
4021: FROM ozf_request_headers_all_b
4022: WHERE request_header_id = pc_agreement_id;
4023:
4024: BEGIN
4025: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4101: FROM ozf_request_headers_all_b

4097:
4098: CURSOR get_spo_agreement_csr (pc_agreement_name VARCHAR2)
4099: IS
4100: SELECT request_header_id
4101: FROM ozf_request_headers_all_b
4102: WHERE agreement_number = pc_agreement_name;
4103:
4104: /*
4105:

Line 4116: FROM ozf_request_headers_all_b

4112:
4113: CURSOR chk_spo_agreement ( pc_agreement_id NUMBER )
4114: IS
4115: SELECT 'X'
4116: FROM ozf_request_headers_all_b
4117: WHERE request_header_id = pc_agreement_id;
4118: */
4119:
4120: -- [BEGINN OF BUG FIXING: Agreement is null]

Line 4133: FROM ozf_request_headers_all_b a

4129:
4130: -- [BEGIN OF BUG 4237990 FIXING]
4131: CURSOR get_spo_agreement_id(cv_agreement_name VARCHAR) IS
4132: SELECT a.request_header_id
4133: FROM ozf_request_headers_all_b a
4134: , qp_list_headers_vl b
4135: WHERE a.offer_id = b.list_header_id
4136: AND a.status_code = 'APPROVED'
4137: AND b.name = cv_agreement_name;