[Home] [Help]
40: CURSOR l_region_api_csr(db_reg_id NUMBER,
41: db_reg_code VARCHAR2) IS
42: select count(*), max(ar.database_object_name)
43: from
44: ak_regions ar,
45: ak_region_items ari
46: where
47: ar.region_application_id = db_reg_id and
48: ar.region_code = db_reg_code and