517: SELECT c.claim_number
518: , c.reason_code_id
519: , r.name
520: FROM ozf_claims c
521: , ozf_reason_codes_vl r
522: WHERE c.claim_id = cv_claim_id
523: AND c.reason_code_id = r.reason_code_id;
524:
525:
2678: , c.object_version_number
2679: , c.reason_code_id
2680: , r.name
2681: FROM ozf_claims c
2682: , ozf_reason_codes_vl r
2683: WHERE c.claim_id = cv_claim_id
2684: AND c.reason_code_id = r.reason_code_id;
2685:
2686: -- Fix for 5182492