APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on OZF_REQUEST_HEADERS_ALL_B

Line 731: FROM ozf_request_headers_all_b

727: AND ln.claim_line_id = cv_claim_line_id;
728:
729: CURSOR csr_offer_id(cv_request_id IN NUMBER) IS
730: SELECT offer_id
731: FROM ozf_request_headers_all_b
732: WHERE request_header_id = cv_request_id;
733:
734: CURSOR csr_offer_type(cv_offer_id IN NUMBER) IS
735: SELECT offer_type

Line 1268: , ozf_request_headers_all_b r

1264: CURSOR csr_request_offer(cv_request_id IN NUMBER) IS
1265: SELECT o.qp_list_header_id
1266: , o.offer_type
1267: FROM ozf_offers o
1268: , ozf_request_headers_all_b r
1269: WHERE o.qp_list_header_id = r.offer_id
1270: AND r.request_header_id = cv_request_id;
1271:
1272: BEGIN

Line 5814: , ozf_request_headers_all_b r

5810: SELECT r.request_header_id
5811: , r.request_number
5812: , s.agreement_name
5813: FROM ozf_resale_lines_int s
5814: , ozf_request_headers_all_b r
5815: WHERE s.resale_batch_id = cv_batch_id
5816: AND s.agreement_name = r.agreement_number
5817: AND r.partner_id = cv_partner_id
5818: AND r.status_code = 'APPROVED'

Line 5849: ozf_request_headers_all_b r

5845: , s.currency_code
5846: , sum(s.quantity)
5847: , sum(s.total_accepted_amount)
5848: FROM ozf_resale_lines_int_all s,
5849: ozf_request_headers_all_b r
5850: WHERE s.resale_batch_id = cv_batch_id
5851: AND s.status_code = 'PROCESSED'
5852: AND s.agreement_name = r.agreement_number
5853: AND r.partner_id = cv_partner_id