DBA Data[Home] [Help]

APPS.OZF_PARTNER_CLAIM_GRP dependencies on OZF_CLAIM_LINES_ALL

Line 84: , ozf_claim_lines_all ln

80: , ut.object_type
81: , ut.object_id
82: FROM ozf_funds_utilized_all_b ut
83: , ozf_claim_lines_util_all lu
84: , ozf_claim_lines_all ln
85: WHERE ln.claim_id = cv_claim_id
86: AND ln.claim_line_id = lu.claim_line_id
87: AND lu.utilization_id = ut.utilization_id
88: AND ut.object_type = 'ORDER';

Line 291: UPDATE ozf_claim_lines_all

287: , l_source_object_class
288: , l_source_object_id;
289: EXIT WHEN csr_utiz_order%NOTFOUND;
290: IF l_source_object_id IS NOT NULL THEN
291: UPDATE ozf_claim_lines_all
292: SET source_object_class = l_source_object_class,
293: source_object_id = l_source_object_id,
294: object_version_number = object_version_number + 1
295: WHERE claim_line_id = l_claim_line_id;