APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on OZF_CLAIM_LINES_ALL

Line 2109: UPDATE ozf_claim_lines_all

2105:
2106: END IF;
2107:
2108: -- Update Claim Line: set earnings_associated_flag to TRUE
2109: UPDATE ozf_claim_lines_all
2110: SET earnings_associated_flag = 'T'
2111: WHERE claim_line_id = l_line_util_rec.claim_line_id;
2112: END IF;
2113:

Line 2556: UPDATE ozf_claim_lines_all

2552: );
2553:
2554: ------ Update Claim Line: set earnings_associated_flag to TRUE -----
2555: IF l_line_util_rec.update_from_tbl_flag = FND_API.g_false THEN
2556: UPDATE ozf_claim_lines_all
2557: SET earnings_associated_flag = 'T'
2558: WHERE claim_line_id = l_line_util_rec.claim_line_id;
2559: END IF;
2560:

Line 3504: UPDATE ozf_claim_lines_all

3500: FETCH csr_final_lu_acctd_amt INTO l_final_lu_acctd_amt;
3501: CLOSE csr_final_lu_acctd_amt;
3502:
3503: IF l_final_lu_acctd_amt = 0 OR l_final_lu_acctd_amt IS NULL THEN
3504: UPDATE ozf_claim_lines_all
3505: SET earnings_associated_flag = 'F'
3506: WHERE claim_line_id = p_line_util_tbl(1).claim_line_id;
3507: END IF;
3508:

Line 5560: from ozf_claim_lines_all

5556: , buy_group_cust_account_id
5557: , buy_group_party_id
5558: , select_cust_children_flag
5559: , prorate_earnings_flag
5560: from ozf_claim_lines_all
5561: WHERE claim_line_id = cv_claim_line_id;
5562:
5563: --used to derive old_total_amount
5564: CURSOR csr_sum_util_amounts(cv_claim_line_id IN NUMBER) IS

Line 8441: UPDATE ozf_claim_lines_all

8437: CLOSE csr_final_lu_amt;
8438:
8439: IF l_final_lu_amt = 0 OR
8440: l_final_lu_amt IS NULL THEN
8441: UPDATE ozf_claim_lines_all
8442: SET earnings_associated_flag = 'F'
8443: WHERE claim_line_id = p_funds_util_flt.claim_line_id;
8444: END IF;
8445:

Line 8819: ,ozf_claim_lines_all cln

8815: CURSOR csr_line_utils(cv_claim_id IN NUMBER) IS
8816: SELECT SUM(lu.scan_unit * amp.quantity)
8817: ,lu.utilization_id
8818: FROM ozf_claim_lines_util_all lu
8819: ,ozf_claim_lines_all cln
8820: ,ams_act_products amp
8821: WHERE cln.claim_id = cv_claim_id
8822: AND lu.claim_line_id = cln.claim_line_id
8823: AND lu.activity_product_id = amp.activity_product_id

Line 9722: FROM ozf_claim_lines_all lines

9718: , item_id
9719: -- , acctd_amount
9720: , amount --7169388
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