APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on OZF_SD_REQUEST_HEADERS_ALL_B

Line 817: FROM ozf_sd_request_headers_all_b

813:
814: --Ship - Debit Enhancements / Added by Pranay
815: CURSOR csr_sd_offer_id(cv_request_id IN NUMBER) IS
816: SELECT offer_id
817: FROM ozf_sd_request_headers_all_b
818: WHERE request_header_id = cv_request_id;
819: --Bug# 8632964 fixed by anuj & muthsubr (+)
820: CURSOR sysparam_accrual_flag_csr (p_resale_batch_id IN NUMBER)
821: IS

Line 11985: , ozf_sd_request_headers_all_b req

11981: , fund.approved_in_currency --7231613 --//SD MC
11982: FROM ozf_claim_lines_all lines
11983: , ozf_offers offr
11984: , ozf_act_budgets fund
11985: , ozf_sd_request_headers_all_b req
11986: WHERE claim_id = cv_claim_id
11987: AND lines.activity_id = req.request_header_id
11988: AND req.offer_id = offr.qp_list_header_id
11989: AND offr.qp_list_header_id = fund.act_budget_used_by_id

Line 12004: , ozf_sd_request_headers_all_b req

12000: , lines.amount
12001: , offr.transaction_currency_code
12002: FROM ozf_claim_lines_all lines
12003: , ozf_offers offr
12004: , ozf_sd_request_headers_all_b req
12005: WHERE claim_id = cv_claim_id
12006: AND lines.activity_id = req.request_header_id
12007: AND req.offer_id = offr.qp_list_header_id;
12008:

Line 12012: FROM ozf_sd_request_headers_all_b

12008:
12009: --Added created_by for bug 7578152
12010: CURSOR csr_request_currency(cv_request_id IN NUMBER) IS
12011: SELECT request_currency_code, org_id, created_by
12012: FROM ozf_sd_request_headers_all_b
12013: WHERE request_header_id = cv_request_id;
12014:
12015: CURSOR csr_request_header(cv_request_id IN NUMBER) IS
12016: SELECT DISTINCT

Line 12052: FROM ozf_sd_request_headers_all_b req

12048: , exchange_rate_type;
12049:
12050: CURSOR cur_offer_currency(cv_request_id IN NUMBER) IS
12051: SELECT offr.transaction_currency_code
12052: FROM ozf_sd_request_headers_all_b req
12053: , ozf_offers offr
12054: WHERE offr.qp_list_header_id = req.offer_id
12055: AND req.request_header_id = cv_request_id;
12056: