APPS.OZF_CLAIM_DEF_RULE_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 23

     SELECT claim_type_id, reason_code_id , custom_setup_id
     FROM  OZF_CLAIM_DEF_RULES
     WHERE CLAIM_CLASS = cv_claim_class
     AND ( ( SOURCE_OBJECT_CLASS is null AND cv_source_object is null )
         OR (SOURCE_OBJECT_CLASS = cv_source_object ) )
     AND ENABLED_FLAG = 'Y';

Line: 31

     select claim_type_id
     from ozf_sys_parameters;

Line: 35

     select reason_code_id
     from ozf_sys_parameters;

Line: 39

     SELECT custom_setup_id
     FROM ams_custom_setups_vl
     WHERE application_id = 682
     AND enabled_flag = 'Y'
     AND custom_setup_id = cv_custom_setup_id;

Line: 46

     SELECT COUNT(custom_setup_id)
     FROM ams_custom_setups_vl
     WHERE application_id = 682
     AND enabled_flag = 'Y'
     AND object_type = 'CLAM'
     AND activity_type_code = cv_claim_class;

Line: 54

     SELECT custom_setup_id
     FROM ams_custom_setups_vl
     WHERE application_id = 682
     AND enabled_flag = 'Y'
     AND object_type = 'CLAM'
     AND activity_type_code = cv_claim_class;