1548: WHERE claim_id = cv_claim_id;
1549:
1550: CURSOR csr_user_status_id(cv_status_code IN VARCHAR2) IS
1551: SELECT user_status_id
1552: FROM ams_user_statuses_vl
1553: WHERE system_status_type = 'OZF_CLAIM_STATUS'
1554: AND system_status_code = cv_status_code;
1555:
1556: l_user_status_id NUMBER;
1732: WHERE claim_id = cv_claim_id;
1733:
1734: CURSOR csr_user_status_id(cv_status_code IN VARCHAR2) IS
1735: SELECT user_status_id
1736: FROM ams_user_statuses_vl
1737: WHERE system_status_type = 'OZF_CLAIM_STATUS'
1738: AND system_status_code = cv_status_code;
1739:
1740: l_claim_id NUMBER;