APPS.OZF_PRE_PROCESS_PVT dependencies on OZF_REQUEST_HEADERS_ALL_B

Line 2348: FROM ozf_request_headers_all_b

2344: ANd b.list_header_id = cv_price_list_id;
2345:
2346: CURSOR spr_org(cv_reqeust_header_id IN NUMBER) IS
2347: SELECT org_id
2348: FROM ozf_request_headers_all_b
2349: WHERE request_header_id = cv_reqeust_header_id;
2350:
2351: l_exchange_rate_type VARCHAR2(100);
2352: l_exchange_rate NUMBER;

Line 4349: FROM ozf_request_headers_all_b

4345:
4346: CURSOR get_spo_agreement_name_csr(pc_agreement_id NUMBER)
4347: IS
4348: SELECT agreement_number
4349: FROM ozf_request_headers_all_b
4350: WHERE request_header_id = pc_agreement_id;
4351:
4352: BEGIN
4353: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4431: FROM ozf_request_headers_all_b

4427:
4428: CURSOR get_spo_agreement_csr (pc_agreement_name VARCHAR2)
4429: IS
4430: SELECT request_header_id
4431: FROM ozf_request_headers_all_b
4432: WHERE agreement_number = pc_agreement_name;
4433:
4434: /*
4435:

Line 4446: FROM ozf_request_headers_all_b

4442:
4443: CURSOR chk_spo_agreement ( pc_agreement_id NUMBER )
4444: IS
4445: SELECT 'X'
4446: FROM ozf_request_headers_all_b
4447: WHERE request_header_id = pc_agreement_id;
4448: */
4449:
4450: -- [BEGINN OF BUG FIXING: Agreement is null]

Line 4463: FROM ozf_request_headers_all_b a

4459:
4460: -- [BEGIN OF BUG 4237990 FIXING]
4461: CURSOR get_spo_agreement_id(cv_agreement_name VARCHAR) IS
4462: SELECT a.request_header_id
4463: FROM ozf_request_headers_all_b a
4464: , qp_list_headers_vl b
4465: WHERE a.offer_id = b.list_header_id
4466: AND a.status_code = 'APPROVED'
4467: AND b.name = cv_agreement_name;