DBA Data[Home] [Help]

APPS.OZF_CLAIM_PUB dependencies on OZF_CLAIM_TYPES_VL

Line 2901: FROM ozf_claim_types_vl

2897: WHERE claim_id = cv_parent_claim_id;
2898:
2899: CURSOR claim_type_id_csr(cv_claim_type_id IN NUMBER) IS
2900: SELECT claim_type_id
2901: FROM ozf_claim_types_vl
2902: WHERE claim_type_id = cv_claim_type_id
2903: AND NVL(end_date,SYSDATE) >= SYSDATE;
2904:
2905: CURSOR reason_code_id_csr(cv_reason_code_id IN NUMBER) IS