APPS.OZF_SETTLEMENT_DOC_PVT dependencies on OZF_CLAIM_LINES_ALL

Line 898: UPDATE ozf_claim_lines_all

894: x_return_status := FND_API.g_ret_sts_success;
895:
896: ------------------------ start -------------------------
897: BEGIN
898: UPDATE ozf_claim_lines_all
899: SET payment_status = 'PAID'
900: WHERE claim_line_id = p_claim_line_id;
901: EXCEPTION
902: WHEN OTHERS THEN

Line 1569: ,ozf_claim_lines_all l

1565: SUM(lu.acctd_amount),
1566: SUM(lu.plan_curr_amount),
1567: SUM(lu.univ_curr_amount)
1568: FROM ozf_claim_lines_util_all lu
1569: ,ozf_claim_lines_all l
1570: ,ozf_funds_utilized_all_b fu
1571: WHERE l.claim_line_id = lu.claim_line_id
1572: AND fu.utilization_id = lu.utilization_id
1573: AND l.claim_id = cv_claim_id

Line 3124: UPDATE ozf_claim_lines_all

3120: UPDATE ozf_claims_all
3121: SET payment_status = 'INTERFACED'
3122: WHERE claim_id = l_claim_rma_fetch(i).claim_id;
3123:
3124: UPDATE ozf_claim_lines_all
3125: SET payment_status = 'PAID'
3126: WHERE claim_id = l_claim_rma_fetch(i).claim_id;
3127: END IF;
3128: END IF; -- end if l_claim_rma_fetch.claim_id is not null and g_miss_num