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:
2654: , c.object_version_number
2655: , c.reason_code_id
2656: , r.name
2657: FROM ozf_claims c
2658: , ozf_reason_codes_vl r
2659: WHERE c.claim_id = cv_claim_id
2660: AND c.reason_code_id = r.reason_code_id;
2661:
2662: -- Fix for 5182492