APPS.OZF_SETTLEMENT_DOC_PVT dependencies on OZF_CLAIM_LINES_ALL

Line 1133: UPDATE ozf_claim_lines_all

1129: x_return_status := FND_API.g_ret_sts_success;
1130:
1131: ------------------------ start -------------------------
1132: BEGIN
1133: UPDATE ozf_claim_lines_all
1134: SET payment_status = 'PAID'
1135: WHERE claim_line_id = p_claim_line_id;
1136: EXCEPTION
1137: WHEN OTHERS THEN

Line 1933: ,ozf_claim_lines_all l

1929: SUM(lu.plan_curr_amount),
1930: SUM(lu.univ_curr_amount),
1931: SUM(lu.util_curr_amount) -- 8710054
1932: FROM ozf_claim_lines_util_all lu
1933: ,ozf_claim_lines_all l
1934: ,ozf_funds_utilized_all_b fu
1935: WHERE l.claim_line_id = lu.claim_line_id
1936: AND fu.utilization_id = lu.utilization_id
1937: AND l.claim_id = cv_claim_id

Line 3596: UPDATE ozf_claim_lines_all

3592: UPDATE ozf_claims_all
3593: SET payment_status = 'INTERFACED'
3594: WHERE claim_id = l_claim_rma_fetch(i).claim_id;
3595:
3596: UPDATE ozf_claim_lines_all
3597: SET payment_status = 'PAID'
3598: WHERE claim_id = l_claim_rma_fetch(i).claim_id;
3599: END IF;
3600: END IF; -- end if l_claim_rma_fetch.claim_id is not null and g_miss_num