APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on OZF_SD_REQUEST_HEADERS_ALL_B

Line 742: FROM ozf_sd_request_headers_all_b

738:
739: --Ship - Debit Enhancements / Added by Pranay
740: CURSOR csr_sd_offer_id(cv_request_id IN NUMBER) IS
741: SELECT offer_id
742: FROM ozf_sd_request_headers_all_b
743: WHERE request_header_id = cv_request_id;
744:
745: BEGIN
746: OPEN csr_line_flt(px_funds_util_flt.claim_line_id);

Line 9725: , ozf_sd_request_headers_all_b req

9721: , fund.approved_in_currency --7231613
9722: FROM ozf_claim_lines_all lines
9723: , ozf_offers offr
9724: , ozf_act_budgets fund
9725: , ozf_sd_request_headers_all_b req
9726: WHERE claim_id = cv_claim_id
9727: AND lines.activity_id = req.request_header_id
9728: AND req.offer_id = offr.qp_list_header_id
9729: AND offr.qp_list_header_id = fund.act_budget_used_by_id

Line 9736: FROM ozf_sd_request_headers_all_b

9732:
9733: --Added created_by for bug 7578152
9734: CURSOR csr_request_currency(cv_request_id IN NUMBER) IS
9735: SELECT request_currency_code, org_id, created_by
9736: FROM ozf_sd_request_headers_all_b
9737: WHERE request_header_id = cv_request_id;
9738:
9739: CURSOR csr_request_header(cv_request_id IN NUMBER) IS
9740: SELECT DISTINCT

Line 9773: FROM ozf_sd_request_headers_all_b req

9769: , product_id;
9770:
9771: CURSOR cur_offer_currency(cv_request_id IN NUMBER) IS
9772: SELECT offr.transaction_currency_code
9773: FROM ozf_sd_request_headers_all_b req
9774: , ozf_offers offr
9775: WHERE offr.qp_list_header_id = req.offer_id
9776: AND req.request_header_id = cv_request_id;
9777: