APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on OZF_CLAIM_LINES_ALL

Line 295: , ozf_claim_lines_all line

291: */
292: CURSOR csr_object_class (cv_claim_line_id IN NUMBER) IS
293: SELECT cla.source_object_class
294: FROM ozf_claims_all cla
295: , ozf_claim_lines_all line
296: WHERE cla.claim_id = line.claim_id
297: AND line.claim_line_id = cv_claim_line_id;
298: --Bug# 8513457 fixed by ateotia (-)
299:

Line 2560: UPDATE ozf_claim_lines_all

2556: --End of fix for Bug 12369487
2557:
2558:
2559: -- Update Claim Line: set earnings_associated_flag to TRUE
2560: UPDATE ozf_claim_lines_all
2561: SET earnings_associated_flag = 'T'
2562: WHERE claim_line_id = l_line_util_rec.claim_line_id;
2563: END IF;
2564:

Line 3859: UPDATE ozf_claim_lines_all

3855: FETCH csr_final_lu_acctd_amt INTO l_final_lu_acctd_amt;
3856: CLOSE csr_final_lu_acctd_amt;
3857:
3858: IF l_final_lu_acctd_amt = 0 OR l_final_lu_acctd_amt IS NULL THEN
3859: UPDATE ozf_claim_lines_all
3860: SET earnings_associated_flag = 'F'
3861: WHERE claim_line_id = p_line_util_tbl(1).claim_line_id;
3862: END IF;
3863:

Line 6654: from ozf_claim_lines_all

6650: , buy_group_party_id
6651: , select_cust_children_flag
6652: , prorate_earnings_flag
6653: , utilization_id -- Added For Bug 8402328
6654: from ozf_claim_lines_all
6655: WHERE claim_line_id = cv_claim_line_id;
6656:
6657: --used to derive old_total_amount
6658: CURSOR csr_sum_util_amounts(cv_claim_line_id IN NUMBER) IS

Line 10831: UPDATE ozf_claim_lines_all

10827: CLOSE csr_final_lu_amt;
10828:
10829: IF l_final_lu_amt = 0 OR
10830: l_final_lu_amt IS NULL THEN
10831: UPDATE ozf_claim_lines_all
10832: SET earnings_associated_flag = 'F'
10833: WHERE claim_line_id = p_funds_util_flt.claim_line_id;
10834: END IF;
10835:

Line 11201: ,ozf_claim_lines_all cln

11197: CURSOR csr_line_utils(cv_claim_id IN NUMBER) IS
11198: SELECT SUM(lu.scan_unit * amp.quantity)
11199: ,lu.utilization_id
11200: FROM ozf_claim_lines_util_all lu
11201: ,ozf_claim_lines_all cln
11202: ,ams_act_products amp
11203: WHERE cln.claim_id = cv_claim_id
11204: AND lu.claim_line_id = cln.claim_line_id
11205: AND lu.activity_product_id = amp.activity_product_id

Line 11982: FROM ozf_claim_lines_all lines

11978: , item_id
11979: -- , acctd_amount
11980: , amount --7169388
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

Line 12002: FROM ozf_claim_lines_all lines

11998: , lines.item_type
11999: , lines.item_id
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

Line 12936: FROM ozf_claim_lines_all

12932: WHERE claim_id = cv_claim_id;
12933:
12934: CURSOR claim_line_id_csr(p_id in number) IS
12935: SELECT claim_line_id, object_version_number
12936: FROM ozf_claim_lines_all
12937: WHERE claim_id = p_id
12938: AND (earnings_associated_flag IS NULL
12939: OR earnings_associated_flag ='F');
12940: