APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on OZF_REQUEST_HEADERS_ALL_B

Line 806: FROM ozf_request_headers_all_b

802: AND ln.claim_line_id = cv_claim_line_id;
803:
804: CURSOR csr_offer_id(cv_request_id IN NUMBER) IS
805: SELECT offer_id
806: FROM ozf_request_headers_all_b
807: WHERE request_header_id = cv_request_id;
808:
809: CURSOR csr_offer_type(cv_offer_id IN NUMBER) IS
810: SELECT offer_type

Line 1465: , ozf_request_headers_all_b r

1461: CURSOR csr_request_offer(cv_request_id IN NUMBER) IS
1462: SELECT o.qp_list_header_id
1463: , o.offer_type
1464: FROM ozf_offers o
1465: , ozf_request_headers_all_b r
1466: WHERE o.qp_list_header_id = r.offer_id
1467: AND r.request_header_id = cv_request_id;
1468: -- Added For Multi Currency - kpatro (As For Public API this is the starting point)
1469: CURSOR csr_function_currency IS

Line 6912: , ozf_request_headers_all_b r

6908: , r.offer_type
6909: --POS Batch Processing by profiles by ateotia (-)
6910: , s.agreement_name
6911: FROM ozf_resale_lines_int s
6912: , ozf_request_headers_all_b r
6913: WHERE s.resale_batch_id = cv_batch_id
6914: AND s.agreement_name = r.agreement_number
6915: AND r.partner_id = cv_partner_id
6916: AND r.status_code = 'APPROVED'

Line 7409: ozf_request_headers_all_b r

7405: , sum(s.quantity)
7406: , sum(s.total_accepted_amount)
7407:
7408: FROM ozf_resale_lines_int_all s,
7409: ozf_request_headers_all_b r
7410: WHERE s.resale_batch_id = cv_batch_id
7411: AND s.status_code = 'PROCESSED'
7412: AND s.agreement_name = r.agreement_number
7413: AND r.partner_id = cv_partner_id